Excel Formula Help Please [Closed]

Report
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 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
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!