Exclude data from summary totals when hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write a formula for a subtotal summary cell that will exclude
data when the row is hidden and will not produce error values if data is
deleted. They should also allow for the insertion of additional rows of
data without requiring additional edits of the formula. The cells need to be
totaled so that the data within the cells is added, and not just counted.
Which I figured out how to do, I just can't get the formula to add the data i
have in the cell.

In addition, I need a formula for a grand total cell that will sum all of
the data in the subtotal formula cells produced as mentioned above.

Thanks for your help....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude hidden data from summary totals 2
Spreadsheet summary automatically referrences totals of worksheets 2
Average of Subtotals in Pivot Table 0
Exclude Hidden Row Values 4
Formula for function/argument "exclude". 0
Sum after Filter, Count after Fliter 2
Hidden cells 1
Need array formula to ignore hidden values 1

Back
Top