CountIF Formula Help

[1Stacy]

Hi,
I think that what I need to use is a CountIF but i am having some trouble.

In long columns I would like a total at the bottom that just says if there were any entries in the above.

I have a lot of data in the cells - alpha values of R, U, I, F, D and I just want the Total to say if there were any entries in the column.

I do not need to know what entry is in the cells just if there is one.

If there is any alpha value in the column I would like it to say 'A'

[Tony Valko]

Does this do what you want?

=COUNTA(B2:B226)

Copy across as needed.

[Jonmo1]

Try

=IF(COUNTIF(B2:B226,"?*"),"A","")