desert rat
New Member
Is there a formula you can use to calculate the percentage of data that is only visible on the spreadsheet after it has been filtered?
For Example
I have a SUBTOTAL in Column A, Locations in Column B, and data in Column C
Column B Column C
Los Angeles 15
Los Angeles 10
Miami 9
New York 23
Los Angeles 7
Chicago 4
Miami 17
i then have SUMPRODUCTs to calculate
Total Wins:
>=10
<10
Is there a formula i could use to display a % for the wins >=10 and wins <10 for example if i filtered Column A using "Los Angeles"?
For Example
I have a SUBTOTAL in Column A, Locations in Column B, and data in Column C
Column B Column C
Los Angeles 15
Los Angeles 10
Miami 9
New York 23
Los Angeles 7
Chicago 4
Miami 17
i then have SUMPRODUCTs to calculate
Total Wins:
>=10
<10
Is there a formula i could use to display a % for the wins >=10 and wins <10 for example if i filtered Column A using "Los Angeles"?