|
|
excellent thanks
Quote:
Originally Posted by via135
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
|
|