G Guest Apr 9, 2007 #1 Is there a way to perform a function (like =sum) on a range but only include the cells that are visible?
Is there a way to perform a function (like =sum) on a range but only include the cells that are visible?
P Peo Sjoblom Apr 9, 2007 #2 From Excel 2033 onwards you can use the SUBTOTAL function, it is clearly explained in help. In previous versions at least down to 97 you can use SUBTOTAL when you filter rows but not hide them, from 2003 you can use it on hidden rows as well
From Excel 2033 onwards you can use the SUBTOTAL function, it is clearly explained in help. In previous versions at least down to 97 you can use SUBTOTAL when you filter rows but not hide them, from 2003 you can use it on hidden rows as well