Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbie question- how do I add up characters?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbie question- how do I add up characters?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
newbie question- how do I add up characters?
In article , 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 If you use 1 (for turned up say) and 0 in future, the problem goes away. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
If Then Question from Newbie. . . | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
newbie question | New Users to Excel | |||
Newbie question | New Users to Excel |