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