Excel Formula Help Please

Closed
Tammy - Feb 24, 2012 at 09:56 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Feb 28, 2012 at 09:12 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Feb 28, 2012 at 09:12 AM
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
0