English Formula Question

[Antonow]

Hello World!
Here's a quick formula question, I've been using Excel in my mother language, and recently I got a new job where they only use English excel. I've been trying to automate an spreadsheet, pretty simple but every time I try to use SUMIFS it only sum the first value.

Here's my example. (it's a huge spreadsheet with all the months, thus it has 10 in the formula)

Month (A) - Name (B) - $ refueled (C)
10.............Jhon Doe.......150.22.......
10.............Regina............50.00.......
10.............Jhon Doe.......180.88.......

What I have is SUMIFS(C:C;A:A;10;B:B;"Jhon Doe")
And the result is 150.22 and not 331.10
Can someone help me out here?

Thanks

 

[Fluff]

Firstly, if using the English version you need to change the ; to ,
secondly in an unused cell put
=B2=B4
where B2 & B4 are cells that contain "Jhon Doe", what does the formula return?

 

[Foz1980]

Try;

=SUMIFS(C:C,A:A,10,B:B,"Jhon Doe")