maaate! I'm glad you asked that question, cos the answers helped me save
heaps of time and headaches. the following formula worked for me:

=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="B"),C1:C100)

Excellent forum, it inspired me to join, thanks to all!!



"Roberto Villa Real" wrote:

I need to sum some values in Column C, but with 2 criterias (one criteria for
column A and another criteria for column B).

Exemple:
I need the SUM of values in column C, only if Column A="x" AND Column
B="09/03/05"

A______B__________C____

x____09/03/05_____2.99(*)
j____09/03/05_____10.34
y____09/03/05_____1.78
h____12/03/05_____9.21
x____09/03/05_____5.6(*)
x____10/04/05_____22.5
a____05/05/05_____50.02

Total: (2.99 + 5.6) = 8.59

Hope someone helps me!
Thanks a lot!