ExcelBanter - subtotals

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/118585-subtotals.html)

aspgk

subtotals

1. I have a need to show subtotals only without the detail...
2. Can this be done?

Please advise & thanks

Paulo

Bob Phillips

subtotals

use the subtotal function

=SUBTOTAL(9,A1:A10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"aspgk" wrote in message
...
1. I have a need to show subtotals only without the detail...
2. Can this be done?

Please advise & thanks

Paulo

All times are GMT +1. The time now is 04:28 AM.