You are reading a single comment by @rhowe and its replies. Click here to read the full conversation.
  • 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.

About

Avatar for rhowe @rhowe started