| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Subtotal in table
I have a spreadsheet with several different years of data in one row (last
year, this year, original plan). I can create a table to subtotal by different criteria, but I'd like to add a subtotal based on the text in another row. Example: Sales at Cost are in column E. The year (TY, LY) is in column D. Is it possible to subtotal only visible cells in column E when column D="TY"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional subtotal function | Excel Worksheet Functions | |||
| conditional subtotal counting | Excel Worksheet Functions | |||
| Conditional SUBTOTAL | Excel Discussion (Misc queries) | |||
| Is there a command like subtotal but with a conditional? | Excel Worksheet Functions | |||
| Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions | |||
Threaded Mode
