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

  • Thread starter Thread starter yadang
  • Start date Start date
Y

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
 
yadang,

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

HTH,
Bernie
MS Excel MVP
 
See help on SUBTOTAL function.

To COUNT use =SUBTOTAL(2,range)


Gord Dibben MS Excel MVP
 
Back
Top