Thread: [Solved] Auto Sum calculate the values of rows that are hidden ...
View Single Post
 
Old 02-06-2018, 06:53 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
  
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default
Thanks for the support.

Code:
 
=Subtotal(function number, data range)
The function number to sum filtered data is 9.
The formula would be defined as follows:
Code:
=Subtotal(9,A1:A10)
Reply With Quote