Sumif Question

I have my data set up so that if the data in the row doesn't have a date next to it, I have not been paid. I want to add all of the amounts that I have not been paid for but have no idea how to use "blank cell" as my criteria in my sum if question. Can someone please help me?

Let's say the amounts are in B2:B26 and the dates / blanks in C2:C26.

The following formula will sum the amounts for which the corresponding cell in column C is blank:

=SUMIF(C2:C26,"",B2:B26)

Thankyou! Another question for you, the spreadsheet with the equation above does not always automatically update itself, and I've made sure the calculations are set to automatic and not manual. Is it because the cells in "B" are formatted as dates? How can I fix this?

Thansk!

The SUMIF formula should be updated automatically; I don't know why it doesn't for you. Sorry!