You are reading a single comment by @Sam_w and its replies.
Click here to read the full conversation.
-
Use the subtotal function http://www.extendoffice.com/documents/excel/1286-excel-sum-filtered-rows.html#a1
Use the subtotal function http://www.extendoffice.com/documents/excel/1286-excel-sum-filtered-rows.html#a1
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Sam_w
How does one, in Excel 2010, set it up so that hidden or filtered out cells are excluded from sum formulas?