Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM all Instances Q
How could I achieve the following via formula
I want to add up all the instances that certain numbers appear in Col B with their corresponding values in COL D e.g. if 1 or 3 or 6 or 20 or 26 or 30 or 55 appears in Row1 then add the value that appears in Row1 COL D and do this for every row in sheet where a values exist in COL B. I know how I could do it if I was looking for only 1 instance in ColB, but the multi instances has me guessing Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting % of Instances | Excel Worksheet Functions | |||
Excel in Two instances | Excel Discussion (Misc queries) | |||
3 Instances | Excel Discussion (Misc queries) | |||
linking certain instances | Excel Discussion (Misc queries) | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions |