Counting Frequency of Filtered Data

T

tom

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
 
D

Domenic

Try...

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

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top