I am using a sumifs formula, everything works fine except for the fact that i want to sum everything that is not XYZ value, basically I'm looking at some postal codes and i want to know how much postcodes are not in a specific area.
I'm looking for a way to tell excel to add everything that is not let's say : N6C, N7A, N8A...
A B
N6C 180
N7A 150
A1F 120
A6K 50
Bookmarks