Reputation: 5215
I want to sum up all values that go for a certain country.
I tried:
=SUMIF(B2:B7;D2=$A$2:$A$7)
However, I get 0
back as seen in the picture below.
Any recommendations what I am doing wrong?
Upvotes: 2
Views: 81
Reputation: 22661
You need to specify the 'test' range and the 'sum' range as separate parameters: try
=SUMIF($A2:$A7; D2; $B2:$B7)
Upvotes: 3