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(D1521="1", SUM(F15:F21))

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

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

Try SUMIF, i.e.

=SUMIF(D1521,1,F15:F21)

you only need to put quotes around the 1 if data in D1521 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

Perfect!

thaks for the very fast reply Bondi!
gR


"Bondi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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
>