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 |
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 |