# COUNT AND SUMIFS ... TO NOT INCLUDE CERTAIN CRITERIAS

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 :(

Tags:

• 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! ☺️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!