| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing cell values based on the value of another
Greetings to all,
I need to sum cell values based on the value of another. Here is the example... A B 1 44.00 $5,874.40 2 44.00 $- 3 44.00 $- 4 23.00 $516.67 5 44.00 $557.20 If A1:5 = 44 then sum B & the row in column A that equaled 44... So the total should be $6431.60 I've been banging my head on this for a while and just can't seem to figure out where I'm going... TIA, Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing values based on calendar dates | Excel Discussion (Misc queries) | |||
| Summing based on values in other worksheets | Excel Worksheet Functions | |||
| Summing rows based on other column values | Excel Worksheet Functions | |||
| Summing based on N largest / smallest values | Excel Discussion (Misc queries) | |||
| summing values in one row based on values in another row | Excel Worksheet Functions | |||
Threaded Mode
