How do I add numbers in visible cells using Excel 97

[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

 

[Andy Brown]

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

=SUBTOTAL(9,B:B)

Rgds,
Andy

 

[Tom Ogilvy]

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.