Reputation: 4842
I am trying to apply SUMIFS in excel but the second condition is not being applied:
A B C
abc 1 1
abc 1 5
abc 0 0
fgh 1 1
I am trying to get sum of column C
when A
is abc
and B
is 0
I am using:
=SUMIFS(A1:A4;"abc";C1:C4,B1:B4;"0")
but excel throws an error that the function is not valid. Where is my mistake?
Thank you for your suggestions.
Upvotes: 0
Views: 68