Thread: [Solved] Sum visible rows
View Single Post
 
Old 06-19-2023, 02:04 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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)
Reply With Quote