IF COUNTIF & COUNTA on Filtered Visible Cells

  • Thread starter Thread starter Tinä
  • Start date Start date
T

Tinä

Hi,

Using the Formulae below, I can obtain the required data from the
Columns in a non-filtered state.

Column T:
=IF(COUNTIF($V$10:$V10,$V11),COUNTA(INDIRECT("V"&U11+1&":V"&ROW()))-1,COUNTA($V$10:$V10))

Column U (helper column):
=MAX(IF($V$10:$V10=$V11,ROW($V$10:$V10)))

Column V:
Text Data

However, I also need to retrieve filtered data, and so require Formulae
that will take into account Filtered Visible Cells and not the
Non-Filtered data in the columns.

Can the formulae be adapted to work on Filtered Visible Cells.

Thanks
Tinä
 
Hi
could you explain what you're trying to achieve with your formulas
(what is your desired result)
 
If you're trying to count the occurrences of a certain text in V whic
is part of an AutoFilter'ed range....

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Vrange,ROW(Vrange)-MIN(ROW(Vrange)),,1)),--(Vrange="Rome"))

would calculate the frequency of occurrence of "Rome" in Vrange, th
range in column V in the area subjected to AutoFilter.
 
Back
Top