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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using the subtotals (data) can you use muliple functions(sum,max) (https://www.excelbanter.com/excel-worksheet-functions/112660-using-subtotals-data-can-you-use-muliple-functions-sum-max.html)

cooleys

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

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

Marcelo

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

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

All times are GMT +1. The time now is 07:19 AM.