[Solved] Calculate total of only the unpaid bills

[endbrown]

I have created a budget using spreadsheet and have used it for years. One column lists all the bills I have due for the month, with a total of the column at the bottom. I would like to find a way to have that simple equation at the bottom of the delete a cell when the date the bill was paid is added into another cell.

I attached an example. When put the date that I paid the mortgage in cell D3 I'd like "D3" to be deleted from the equation in cell B8.

Thank you.

[endbrown]

My apologies. Small typo in my post. On the last sentence I said I wanted "D3" deleted from the equation. I meant to write "B3"

I appreciate anyone's assistance with this.

[Zizi64]

Study the function SUMIF() in the Help.

[LeslieS]

Expanding on what ZiZi64 said:

Code: Select all

=SUMIF(D3:D7,"=",B3:B7)    

I note this because it may not be obvious or easy to find how to create the criterion where the cell is anything but empty.
That seems to be done with the "=".

[Zizi64]

Here are two similar ways - applied in your sample file:

Budget example_Zizi64.ods

(13.04 KiB) Downloaded 136 times

It calculates the Paid ones, but (I hope) you can modify it to reverse.

[robleyd]

You might also look at the functions NOT() and ISBLANK()

[MrProgrammer]

I would like to find a way to have that simple equation at the bottom of the delete a cell when the date the bill was paid is added into another cell.

[Tutorial] The SUMPRODUCT function, example X06: Sum values in column Y where column X is empty

=SUMIF(D3:D7,"=",B3:B7)

The calculation cannot be accomplished like that in Calc because feeble SUMIF ignores cells where the criteria (D3:D7) is empty. SUMPRODUCT does not have that restriction.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know