Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To sum by grouping
Col A has the following:
A1 - XXX A2-YYY A3-ZZZ A4-XXX A5-CCC A6-YYY B1 to B6 has dates in the date format. I want to sum Col B (to find out the days lapsed) for XXX, YYY, ZZZ etc.... I sorted col A but do not know the formula to do the above. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping | Excel Discussion (Misc queries) | |||
grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) | |||
Grouping by day | Charts and Charting in Excel | |||
Grouping | Excel Discussion (Misc queries) |