=SUMPRODUCT(--(A2:A20="Jul"),--(B2_B20="Smith"),C2:C20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sofia" wrote in message
...
I am trying to sum amounts based on meeting multiple criteria in other
colums. I saw the response to the "contruction guy" posted here, but it
does
not work for my information?

Month Client Amt
Jul Smith 5
Jul Smith 2
Aug Smith 3
Aug Scott 10

I want to calculate total amount per client each month using "sum" and
"if"
statements.

Thank you,

sofia