Hi I have a simple question:
I know how to use SUMIFS as an array but don't know how to make it work when I do not want to include certain values in the sum:
EXAMPLE: How can I convert =SUMIFS($A:$A,$N:$N,{"*Criteria 1*","*Criteria 2*","*Criteria 3*"}) into something like this: SUMIFS($A:$A,$N:$N,{"<>"&"*Criteria 1*","<>"&"*Criteria 2*","<>"&"*Criteria 3*"}). The second formula does not work! How can I make it work for text?
Also I want to sum something not equal to a cell that contains specific text or numbers:
Another example is this: How to convert the statement below into a SUMIFS of A:A where N:N does NOT contain 1,2,3,4,5 etc...
=SUMIFS($A:$A,$N:$N,{1,2,3,4,5,6}) - ????
Thanks for your help
AK
Bookmarks