powercell99
Board Regular
- Joined
- May 14, 2014
- Messages
- 75
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
-> Not Working: =SUMIFS(A1:A100, B1:B100,"<>")
-> But this works now??? =SUMIFS(A1:A100, B1:B100,"<>""")
Weird
Thanks