| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function or something else needed?
I have column E2 to E43 with place names e.g Dawson Creek, Peace River,
GrandePrairie and I want the corresponding numbers in column J2 to J43 1196, 990,946 to sum in cell K49 .. as in if I have 10 dawson creek entries I want the total in K 49 to be 11960 in K50 10 Peace Rver entries to total 9900.. and 10 Grande Prairie entries to total 9460 in K51.. I have put in =Sumif(E2:E43,"Dawson Creek",J2:J43)in K49 and it works but same does not work for K50 and K51 with just changing the Name to Peace River and Grande Prairie respectively... please help.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF help needed | Excel Discussion (Misc queries) | |||
| Help needed with a SUMIF(AND | Excel Discussion (Misc queries) | |||
| SumIf help needed ( I think) | Excel Discussion (Misc queries) | |||
| help needed on "sumif function with multiple ifs" | Excel Discussion (Misc queries) | |||
| SUMIF help needed | Excel Worksheet Functions | |||
Threaded Mode
