IF COUNTIF & COUNTA on Filtered Visible Cells

[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ä

 

[Frank Kabel]

Hi
could you explain what you're trying to achieve with your formulas
(what is your desired result)

 

[Aladin Akyurek]

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.