COUNT AND SUMIFS ... TO NOT INCLUDE CERTAIN CRITERIAS

Stacy Meadows

Hi, I am wanting to =countif({Postcode 2}, does not contain any of the listed postcodes ....

and then the same for a sumif however my brain is not working :(

help please :)

Nick Korna

Hi @Stacy Meadows,

You have a couple of choices on this one:

You can make a long formula to do the OR & NOT:

=COUNTIF({Postcode 2}, NOT(OR(@cell = Postcode1, @cell = Postcode2, @cell = Postcode3)))

^ This is just doing the first 3, but you should get the idea - the numbers will need changing to the relevant row numbers to accommodate the "title" rows.

Alternatively, if your data source only has rows with information (no totals etc.) then you could use:

=COUNT({Postcode 2})-SUM(Count1:Count 14)

This would find the total and then subtract the ones which have already been accounted for.

The SUMIF/SUM formulas would be much the same, just substituting the relevant function in.

Hope this helps, if you've any questions etc. then just post! ☺️