Ok I did that & it worked, now when I try to get the data from another
worksheet it gives me wrong data, do you know why?

=SUMPRODUCT(--(Actual!$F$2:$F$10="G7705"),--(Actual!$G$2:$G$10="300"),Actual!$L$2:$L$10)

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(A1:A10="G7705"),--(B1:B10=300),C1:C10)

Regards,

Peo Sjoblom

"Mestrella31" wrote:

I have 3 colums

colum A G7705
colum B 300
colum C Units

I need sum the units in colum C if colum A & B = "G77053000"

Can somone Help