How does one, in Excel 2010, set it up so that hidden or filtered out cells are excluded from sum formulas?
Use a pivottable? If you want to use the results in a formula, see GETPIVOTDATA
Note that I haven't used Excel in anger in over 4 years and my life is definitely no worse.
@rhowe started
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.
How does one, in Excel 2010, set it up so that hidden or filtered out cells are excluded from sum formulas?