Previous Topic Next Topic

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 December 27, 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses