Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Is it possible to add subtotals for both a sum of a column and a count of the
items in that column in one step? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
The count would have to be in another cell, so why not count the
number of items in an adjacent column when you are setting up the Subtotals parameters? Hope this helps. Pete On Dec 20, 1:47 pm, Number Man wrote: Is it possible to add subtotals for both a sum of a column and a count of the items in that column in one step? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
Function_num (includes hidden values) Function_num (ignores hidden values)
Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM 10 110 VAR 11 111 VARP -- regards from Brazil Thanks in advance for your feedback. Marcelo "Number Man" escreveu: Is it possible to add subtotals for both a sum of a column and a count of the items in that column in one step? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals
use the function "Subtotal", look in help how to use it (start with 9 for
sum, start with 2 for count or 3 for counta) rdwj "Number Man" wrote: Is it possible to add subtotals for both a sum of a column and a count of the items in that column in one step? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |