Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF Function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
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 |
#3
|
|||
|
|||
excellent thanks
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |