ExcelBanter - Excel - Percentage

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel - Percentage (https://www.excelbanter.com/new-users-excel/231192-excel-percentage.html)

Magic1

Excel - Percentage

How do I get a percentage of D6:d13 with the letter "Y" in cell E5

Sheeloo

Excel - Percentage

=COUNTIF(D6:D13,"Y")
will give you the count of cells having "Y" as their value...

"Magic1" wrote:

How do I get a percentage of D6:d13 with the letter "Y" in cell E5

All times are GMT +1. The time now is 02:02 AM.