If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Question: Has SUMIFS formula changed for blank cells?

Thread starter powercell99
Start date Apr 3, 2018
Tags

=sumifsa1a100 blank cells changed summing

powercell99

Board Regular

Apr 3, 2018

Has anyone noticed a changed to the logic or Summing blank cells using the SUMIFS(? the criteria used to be "<>", but i couldnt get it to work. Finally i tried "<>""", and it worked correctly. But thats not the way i remember the formula. Has anyone else noticed the logic changed for summing blank cells?

-> Not Working: =SUMIFS(A1:A100, B1:B100,"<>")

-> But this works now??? =SUMIFS(A1:A100, B1:B100,"<>""")

Weird

Thanks