SUMIF Function

G

GarToms

Hi all,

I have a list of codes in column A1:A10000 and a list of values in
column B1:B10000. When the codes are the same i want the respective
values in B to be summed. The code I lookup is in C1.

I have tried
=SUMIF(A1:A10000,"=C1",B1:B10000)
but it doesn't work. Does anyone know why?

Thanks for any help
 
V

via135

hi!

make a small correction in your formula as under:
=sumif(a1:a10000,c1,b1:b10000)

you will get the result!

regds!

-via135
 
G

GarToms

excellent thanks
hi!

make a small correction in your formula as under:
=sumif(a1:a10000,c1,b1:b10000)

you will get the result!

regds!

-via135

GarToms Wrote:
Hi all,

I have a list of codes in column A1:A10000 and a list of values in
column B1:B10000. When the codes are the same i want the respective
values in B to be summed. The code I lookup is in C1.

I have tried
=SUMIF(A1:A10000,"=C1",B1:B10000)
but it doesn't work. Does anyone know why?

Thanks for any help


--
GarToms


--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=26725
View this thread:
http://www.excelforum.com/showthread.php?threadid=510706
Click to expand...
 
Top