Thread: [Solved] Auto Sum calculate the values of rows that are hidden ...
View Single Post
 
Old 02-06-2018, 06:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
use the SUBTOTAL() function. It sums the filtered values.
Reply With Quote