Excel Formula Help Please

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
Hello,
I have only worked with formulas when working with numbers but I need to know what formula I can use. I need a formula to take a column that only has input of Y and then divided another column with total alpha input to give me a percentage.
Example,
brown, blue, green column B
Y, Y column C
column b would equal 3, column C which equals 2 I need a formula that takes total from column c divided by column b for percentage that is 67%
Any help would be greatly appreciated.


1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
Hi Tammy,

Try this formula:
=COUNTA(C2:C4)/COUNTA(B2:B4)

Then format the cell you put the formula in as percentage.

Best regards,
Trowa