How do I add numbers in visible cells using Excel 97

  • Thread starter Thread starter John Kennedy
  • Start date Start date
J

John Kennedy

I need to add values in visible cells using Excel 97 using
a formula instead of adding values of each cell
individually.

Thank You

John Kennedy
 
If you mean your data is filtered, check out the SUBTOTAL function -- eg:

=SUBTOTAL(9,B:B)

Rgds,
Andy
 
If you are hidding the rows using a filter, then look in help at the
Subtotal worksheet function.

Other than that, there is no built in function that ignores hidden cells.
Perhaps there is a cell value condition you can check - so you could use
Sumif, use the conditional sum wizard.
 
Back
Top