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:

I want to use sum in one column and max in a different column