adding value only if criteria is true
 

Hi all. I've 2 columns (see below)

1 20
3 35
2 10
5 20
4 25
2 30
1 30


I need to get the total for each number on the lefts corrosponding value on
the right.

ie. Total of 1=50
2=40
etc

I tried

=IF(D15:D21="1", SUM(F15:F21))

but no joy, can anyone shed some light?
thanks and regards
gR

adding value only if criteria is true
 

Hi gR,

If we say that your data is in column A and B then you can use SUMIF()
along the lines of :

=SUMIF(A1:A7,"=1",B1:B7)

Regards,
Bondi

adding value only if criteria is true
 

Try SUMIF, i.e.

=SUMIF(D15:D21,1,F15:F21)

you only need to put quotes around the 1 if data in D15:D21 is text
rather than numeric


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559256

adding value only if criteria is true
 

Perfect!

thaks for the very fast reply Bondi!
gR


"Bondi" wrote in message
ups.com...

Hi gR,

If we say that your data is in column A and B then you can use SUMIF()
along the lines of :

=SUMIF(A1:A7,"=1",B1:B7)

Regards,
Bondi