SUMIF with two conditions ?

[Guest]

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

 

[Guest]

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

Regards,

Peo Sjoblom

 

[Guest]

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)

 

[JE McGimpsey]

hard to tell since you don't say what the "wrong data" is...

However, I'd start with making sure that my numbers in Actual!$L$2:$L$10
were really numbers, rather than numbers entered as Text (copy a blank
cell, select your range, then choose Edit/Paste Special, selecting the
Add and Values radio buttons).

 

[Guest]

both coulums are text and I corss check the numbers, to correct sum is 16000
and i don't know were is piking up 7685

 

[Frank Kabel]

Hi
try for each cell in column L the following formula
=ISNUMBER(L2)

this has to return TRUE for all cells

 

[Guest]

False on both colums

Hi
try for each cell in column L the following formula
=ISNUMBER(L2)

this has to return TRUE for all cells

 

[Frank Kabel]

Hi
then your column L does not really contain numeric values (though they may
look like such). You have to convert them back to numbers first:
- change the format of these cells to 'General' or a 'Number' format
- copy an empty cell
- select these values
- goto 'Edit - Paste Special' and choose 'Add'

Now the formula should work

 

[Guest]

Thanks For Everything, It works Know...

MUCHAS GRACIAS de MEXICO

 

[Guest]

Did you get a satisfactory answer to your question? If not, I have another
solution that does not use sum product