Sumif

[AJDionne]

I have been trying to figure out a formula to
compare column A to a cell and compare column B to another cell then SUM the value column C
ex:
A B C
DATE Operation tph
SAT 046-00 8.6
SUN 046-00 0
WED 047-00 7.6
THU 047-00 9.8
SAT 331-00 44.5

I tried
=SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .

[Yogi Anand]

On 2002-04-23 17:26, AJDionne wrote:
I have been trying to figure out a formula to
compare column A to a cell and compare column B to another cell then SUM the value column C
ex:
A B C
DATE Operation tph
SAT 046-00 8.6
SUN 046-00 0
WED 047-00 7.6
THU 047-00 9.8
SAT 331-00 44.5

I tried
=SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .

Hi AJDionne:
You can use the DSUM function:

=DSUM(A1:C6,"tph",D1:E2) ..... giving the result 7.6

where the first argument is data_range A1:C6, second argument is tph (the field to be summed, and the third argument is the criteria range with DATE in cell D1, Operation in cell E1, WED in cell D2, and 047-00 in cell E2./

HTH

Please post back if it works for you otherwise explain a little further and let us take it from there!



_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 14:02 ]