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 :(
help please :)
Answers

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! ☺️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!