Percent Question

[Spook E]

If i have a range of data like:

A B A B B B A C C A

How do i count the number of 'A's in the range and show it as a percentage of the total range i.e:

4 'A's out of 10 = 40%

Thanks

 

[Derek]

Hi there

Assuming your data is in A1 try this formula:

=(LEN(A1)-LEN(SUBSTITUTE(A1,"A","")))/(LEN(SUBSTITUTE(A1," ","")))

cell with formula formatted for percentage

regards
Derek

 

[Doug.T]

If your data is in a range of cells (ie: A1 to A10) then you could use this approach:

=COUNTIF(A1:A10,"A")/COUNTA(A1:A10)

 

[Spook E]

That just gave me the number 0

The range is C8:V8 and i would like the result to be located in AG8

Thanks for the reply!

 

[Spook E]

that works great Doug, thanks