I am currently receiving a #div/0! error in a sumif formula. However:
-I am not dividing in my formula
-The formula worked until today
-The formula is working in other places in my spreadsheet (my formula sums a certain range for a variety of cities, and each 'if' is a different city) only one is not working
-I have checked the entire range that I am trying to sum and do not find any other #div/0! errors
I would appreciate any help anyone can provide. Thanks!
Bookmarks