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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To sum by grouping
Maybe this array formula** :
=MAX(IF(A1:A6="xxx",B1:B6))-MIN(IF(A1:A6="xxx",B1:B6)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Dan" <Dan @discussions.microsoft.com wrote in message ... 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. |
Reply |
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) |