Sum visible rows

soroush.kalantari · #7 06-19-2023, 08:22 PM

Quote:

Originally Posted by p45cal

Why don't you use the built-in functions which deal with hidden/visible rows:
in D6:
=SUBTOTAL(109,D7

12)
or:
=AGGREGATE(9,3,D7

12)

It is because my routine work is such that I am used to hide rows temporaly by “grouping tool” and when I unhide the rows, I don’t want to sum include privously hidden rows which now are visible.
But thank you for your answer. It can solve part of my problem and I learned from your answer some Built in excel function that I didn’t know before.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add Rows to table that will include content controls of previous rows	bobsagat	Word VBA	20	01-27-2020 08:00 AM
VBA color of visible gridlines of tables word (with some merged cells in first rows)	Alvaro.passi	Word VBA	0	07-18-2017 09:11 AM
How to find duplicate rows in a huge excel file containing 500000 rows	Stc25234	Excel Programming	2	06-23-2017 10:51 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM