SUMIF Function

[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


--
GarToms

[via135]

hi!

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

you will get the result!

regds!

-via135

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

[GarToms]

excellent thanks

via135 Wrote:
> 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


--
GarToms