| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Subtotal
=subtotal(9,f2:f4545)
This formula works for totaling ( SUMMING) column F after filtering the items I need. F are amounts. In column E, I have items ( apples, oranges, lemons). I'm in need of a formula that, after doing the dropdown on the top column (filtering), lets say apple, I'll get the subtotal of apples. The same racionality of the given formula above, but directed to counting not to SUM. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal counting formula in cells | Excel Discussion (Misc queries) | |||
| conditional subtotal counting | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
