Jonas Palačionis
Jonas Palačionis

Reputation: 4842

Applying SUMIFS() in excel

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

Answers (1)

BigBen
BigBen

Reputation: 50162

Sum_range comes first.

=SUMIFS(C1:C4;A1:A4;"abc";B1:B4;0)

Upvotes: 2

Related Questions