Sum if

[SPLUCENA]

Hi All,

Can somebody please assist me with these issue of mine in excel.

I tried using sumif function but it is not working for me.

I have in the cells the following item. I want to add the value of gas only. SumIf function does not work for me. Please help.


Thanks,

splucena



ROW 1 ROW 2 TOTAL QTY
GAS 500
GAS 100
OTHER 800
GAS 200

 

[Grizlore]

VoG

This returns a zero. Can you see where I am going wrong please?

=SUMPRODUCT(--(Data!$D$2:$D$10=$B$1),--(Data!$R$2:$R$10=$C$3),--(Data!$K$2:$K$10=A5),Data!$S$2:$S$10)

Many Thanks

 

[Grizlore]

This has been sorted

vog

this returns a zero. Can you see where i am going wrong please?
=sumproduct(--(data!$d$2:$d$10=$b$1),--(data!$r$2:$r$10=$c$3),--(data!$k$2:$k$10=a5),data!$s$2:$s$10)

many thanks

seem to workl now (?)