Excel Formula Help Please

Closed
Tammy - Feb 24, 2012 at 09:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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