I have two different formulas that I need to calculate a percentage for visible rows when filtering a list. One formula uses the Countif function for text entries, the other formula uses countif values are >1 in the visible filtered list,
Formulas shold work for Excel 2003 and 2010 versions.
Attached is a spreadsheet with the problem better described
Thank you in advance