Try this:

=COUNTIF(A1:Z1,"Y")

to count the Y's, and:

=COUNTIF(A1:Z1,"O")

to count the O's.

Adjust the range references to suit your data.

Hope this helps.

Pete

On May 2, 11:54*am, louscannon wrote:
Hi, I have a spreadsheet, where I put a Y if the person turns up, and
O if they don't. so, for example, if Joe Bloggs doesn't turn up on the
1/05/08, on his row under the date, I put O. Now, over the months each
person in my group, has varous Y's and O's if he *doesn't show up.
How can all the Y's or all the O's be added up, so giving me an idea
as to how many times Joe's turned up over the months/years?
Lou