Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
118
Views
Topic starter
Hi
I'd like to sumifs of all the rest of the values that do not match a list of criteria.
i.e. Instead of matching a criteria, I'd like to catch all values that do match the list. Hope that makes sense.
Thanks
Posted : 18/11/2024 3:37 pm
That may make sense as the criteria can be be set to match or not. The latter, though, requires a special syntax.
For example:
=SUMIFS(B1:B100,A1:A100,K1,A1:A100,K2)
sums values from B where A matches the values in K1 and K2
=SUMIFS(B1:B100,A1:A100,"<>"&K1,A1:A100,"<>"&K2)
sums values from B where A does NOT match the values in K1 and K2
Posted : 19/11/2024 2:26 am
