none
SumIF no date in the corresponding cell in row then sum that corresponding amount

    Question

  • 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?

    Thursday, July 04, 2013 8:37 PM

Answers

  • 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)


    Regards, Hans Vogelaar

    • Marked as answer by dfersovitch Friday, July 05, 2013 3:24 PM
    Thursday, July 04, 2013 9:07 PM

All replies

  • 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)


    Regards, Hans Vogelaar

    • Marked as answer by dfersovitch Friday, July 05, 2013 3:24 PM
    Thursday, July 04, 2013 9:07 PM
  • 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!

    Friday, July 05, 2013 3:26 PM
  • The SUMIF formula should be updated automatically; I don't know why it doesn't for you. Sorry!

    Regards, Hans Vogelaar

    Friday, July 05, 2013 4:16 PM