ExcelBanter - Excel

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

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

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/244927-excel.html)

RickComputer

Excel

When I have alot of data. I filter down to the data I want to see. How can I
create a sum total of only the data I have filtered down to?

Stefi

Excel

=SUBTOTAL(109;A2:A7)
Adjust range!
Regards,
Stefi

€žRickComputer€ ezt Ã*rta:

When I have alot of data. I filter down to the data I want to see. How can I
create a sum total of only the data I have filtered down to?

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