| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Subtotal
In other words, you want to count how many times apple is displayed in column
E? Try this: =SUBTOTAL(3,E2:E4545) -- Biff Microsoft Excel MVP "Lerner" wrote: =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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Subtotal
Yes, this is exactly what I was looking for.
Now, the formula for' counting' is the same as the one for 'suming' except for number '3' and number '9', if it is not much trouble and you or someone knows the answer: what's the racionality of those numbers(3 and 9)in those two formulas. Thanks T. Valko. "T. Valko" wrote: In other words, you want to count how many times apple is displayed in column E? Try this: =SUBTOTAL(3,E2:E4545) -- Biff Microsoft Excel MVP "Lerner" wrote: =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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Subtotal
The SUBTOTAL function can perform a variety of calculations. Look in Excel
help for SUBTOTAL to see what those calculations are. -- Biff Microsoft Excel MVP "Lerner" wrote: Yes, this is exactly what I was looking for. Now, the formula for' counting' is the same as the one for 'suming' except for number '3' and number '9', if it is not much trouble and you or someone knows the answer: what's the racionality of those numbers(3 and 9)in those two formulas. Thanks T. Valko. "T. Valko" wrote: In other words, you want to count how many times apple is displayed in column E? Try this: =SUBTOTAL(3,E2:E4545) -- Biff Microsoft Excel MVP "Lerner" wrote: =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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting Subtotal
As Biff indicated, 3 and 9 are different parameters of Subtotal formula, 9
makes sum, 3 makes count. "Lerner" wrote: Yes, this is exactly what I was looking for. Now, the formula for' counting' is the same as the one for 'suming' except for number '3' and number '9', if it is not much trouble and you or someone knows the answer: what's the racionality of those numbers(3 and 9)in those two formulas. Thanks T. Valko. "T. Valko" wrote: In other words, you want to count how many times apple is displayed in column E? Try this: =SUBTOTAL(3,E2:E4545) -- Biff Microsoft Excel MVP "Lerner" wrote: =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. |
| Reply |
| 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 | |||
Linear Mode
