Notifications
Clear all
Topic starter
I have a table with 100 data
40 data of which are hidden
How do you summarize only the 80 visible data?
thank you
Posted : 09/03/2018 2:24 pm
Hello,
If by table you mean Excel table and not a range, then use SUBTOTAL.
Check these pages for more information.
https://www.myonlinetraininghub.com/excel-subtotal-formula-explained
https://www.myonlinetraininghub.com/excel-tables
Br,
Anders
Posted : 09/03/2018 2:59 pm
Topic starter
I tried with subtotal and was not able to me.
Attached is the file where the rows are hidden by the Hide command and not by filtering
And write 27 times the number 100 so the result should be 2700
What formula are put into the yellow cell to get the formula?
Posted : 09/03/2018 8:47 pm
Try
=SUBTOTAL(109,A:A)
Sunny
Posted : 09/03/2018 9:15 pm
