sum.if problem

[jamiguel77]

A1=Manuel Perez Rios B1=100.32 C1= Rodrigo Torres Sosa D1= 0
A2=Rodrigo Torres Sosa B2=123.43
A3=Manuel Perez Rios B3=154.56
A4=Manuel Perez Rios B4=432.45
A5=Rodrigo Torres Sosa B5=234.54
A6=Paola Soto Gutierrez B6= 75.67

the forumla in D1 is: =SUM.IF(A1:B6,"=C1",B1:B6) i am wait a result in cell D1 = 357.97 any advice?

thanks

[Pete_UK]

Change the formula to this:

=SUM.IF(A1:A6,C1,B1:B6)

Note the changes in red - I suspect you are not using an English version of Excel, so all you need to change is the red part (SUM.IF would be SUMIF in English).

Hope this helps.

Pete