N Nolan Aug 25, 2004 #1 Is it possible to quickly do a sum of displayed cells in a filtered column without including the hidden cells? Thanx
Is it possible to quickly do a sum of displayed cells in a filtered column without including the hidden cells? Thanx
D Debra Dalgleish Aug 25, 2004 #2 You can use the Subtotal function -- there are instructions in Excel's help files, and here: http://www.contextures.com/xlFunctions01.html#Filter
You can use the Subtotal function -- there are instructions in Excel's help files, and here: http://www.contextures.com/xlFunctions01.html#Filter