software

I have a table of filtered data. For example

a1: 15
a2: 18
a10: 15

cells a3:a9 also have valid numbers but are filtered out.

Is there a way to count the frequency of only the filtered data.

For example in the above, value 15 has a frequency of 2, 18 only one.

Countif calculates the frequency of all rows, not just the visible ones.
Subtotal with option 2 counts the number of visible rows, in this case 3.

Thanks

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),--(A2:A10=
15))

Hope this helps!

In article gt;,
tom gt; wrote:

gt; I have a table of filtered data. For example
gt;
gt; a1: 15
gt; a2: 18
gt; a10: 15
gt;
gt; cells a3:a9 also have valid numbers but are filtered out.
gt;
gt; Is there a way to count the frequency of only the filtered data.
gt;
gt; For example in the above, value 15 has a frequency of 2, 18 only one.
gt;
gt; Countif calculates the frequency of all rows, not just the visible ones.
gt; Subtotal with option 2 counts the number of visible rows, in this case 3.
gt;
gt; Thanks