Subtotals

  • Thread starter Thread starter Number Man
  • Start date Start date
N

Number Man

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?
 
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
 
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:
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Counting Subtotal 4
ABS in SUBTOTAL 3
description of count in subtotal 1
Copy within a subtotal 1
Multiple formulas in subtotal 2
Subtotal/Consolidate/Pivot Table, Lookup ??? 2

Back
Top