Sum visible rows

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Sum visible rows

06-19-2023, 02:04 PM

p45cal

Windows 10 Sum visible rows

Office 2021

Expert

Join Date: Apr 2014

Posts: 948

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

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 PM.