Auto Sum calculate the values of rows that are hidden ...

		Microsoft Office Forums > Microsoft Excel > Excel
Auto Sum calculate the values of rows that are hidden ...

02-06-2018, 06:53 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit Auto Sum calculate the values of rows that are hidden ...

Office 2003

Advanced Beginner

Join Date: Nov 2016

Posts: 82

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate & auto calculate values from other sections in the same word document	Frantic	Word VBA	2	01-24-2015 04:54 PM
VBA to keep hidden rows hidden when filtering	tectonicseer	Excel Programming	1	07-27-2014 11:54 AM
add values to dropdown selections and calculate	guyhs	Word	7	10-24-2012 05:11 PM
hidden rows	gsrikanth	Excel	5	01-19-2012 02:40 PM
calculate average depending on drop-down values	virencm	Word	0	08-06-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 AM.