newbie question- how do I add up characters?

  • Thread starter Thread starter louscannon
  • Start date Start date
L

louscannon

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
 
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
 
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

If you use 1 (for turned up say) and 0 in future, the problem goes away. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top