ExcelBanter - SUMIF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF Function (https://www.excelbanter.com/excel-worksheet-functions/70541-sumif-function.html)

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

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...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=510706

excellent thanks

Quote:

Originally Posted by via135