| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional subtotals
Hi tx12345,
This worked for me: =IF(A3=A2,"",SUM(OFFSET(B2,1-COUNTIF(A:A,A2),0,COUNTIF(A:A,A2),1))) Someone might have a shorter solution, they usually do. Paste this into B2 then fill it down to the bottom of your list. You might also want to look into Excel's automatic subtotals in Help. Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| Conditional Formatting and Subtotals | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting to change subtotals row format | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
