calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had

[yadang]

Is there a way to calculate values in an unlimited range of cells in a
column WITHOUT also calculating values that had previously been filtered
AGAINST?

For instance, I've set up a group of calculating cells to keep track of
the number of times that the the string values "Ad in other paper", "Ad in
community newspaper" and "Ad in a state newspaper" appear in a table which
will grow as new records are added (via a dynamically linked database in
access).

Presently, if I use (B:B), my calculating cells count not only the visible
records, but also the records I hid with a filter on another table that
excluded all values that did not = "Antarctica".

Sorry it's so complex and I am so poor at explaining these things!

Regards


yadang

 

[Bernie Deitrick]

yadang,

Using the SUBTOTAL function will ignore the filtered values. Look at help for the specifics.

HTH,
Bernie
MS Excel MVP

 

[Gord Dibben]

See help on SUBTOTAL function.

To COUNT use =SUBTOTAL(2,range)


Gord Dibben MS Excel MVP