Conditional counting with checkbox

Hi! Here is my table: (editable)

I am trying to figure out how to count spent amount and the remaining one. I am trying to assemble a budgeting template. E.g. i have a sum row, this is the amount to be paid in spetember, how can i decrease the sum if i checked the box in Spent column?

I have added a proposed formula to do what you asked for.

1 Like

can i ask for the proposed solution to be posted here as text.
that way, others who come across this question can see the answer.


1 Like

Sure, here goes:

1 Like

Wow thanks! I guess i have to dig deeper into formulas. Such a powerful thing. Do they mainly work like javascript? i see filter method there etc…

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.