using the subtotals (data) can you use muliple functions(sum,max)

  • Thread starter Thread starter Guest
  • Start date Start date
hi Cooleys

subtotal has:
=subtotal(N,range)

N could be
1 - average
2 - count
3 - counta
4 - Max
5 - Min
6 - Product
7 - STDEV
8 - STDEVP
9 - Sum
10 - VAR
11 - VARP

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"cooleys" escreveu:
 
You must log in or register to reply here.

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

subtotal with sumif nested 1
large combine max fuction issue 1
SUBTOTAL - dynamic selection 3
summing adjacent data in a worksheet 3
Sum after Filter, Count after Fliter 2
Conditional SUBTOTAL in XL210 Table 7
Need array formula to ignore hidden values 1
multiple criteria formula 2

Back
Top