Count certain texts in cells and provide percentage overall

[JaynRW]

Hello

Im using Excel 2007

I have a long column populated with 'A' and 'B' and blank cells. I need to count the 'B's and blank cells, and then have an overall percentage.

For example, there's 10 cells with 2xA, 3xB and 5xblanks and I need the formula to tell me 80%

Can you help please?

Thanks
Jay

[AlKey]

Hi and welcome to the forum,

Try this formula

=(COUNTIF(A1:A10,"B")+COUNTBLANK(A1:A10))/10

Format cell as "%"

or you can also use this one

=SUMPRODUCT(--(A1:A10={"B",""}))/10

	A	B
1	A	80%
2	B
3	A
4	B
5	B
6
7
8
9
10