counting characters in a line
 

I have created a calender grid for each month for employee absentee's. I
have designated an alpha character for each reason an employee may be absent,
(ie "V" for vacation, "S" for sick, etc.) At the end of each row, i would
like to have a cell to calculate all of my "V"'s, "S"'s, etc. HELP?

counting characters in a line
 

I suggest a COUNTIF() formula that covers the entire row; count Vs, Ss,
etc in different cells.

counting characters in a line
 

The CountIF function would work for that.
--
Kevin Backmann


"Johnny D" wrote:

I have created a calender grid for each month for employee absentee's. I
have designated an alpha character for each reason an employee may be absent,
(ie "V" for vacation, "S" for sick, etc.) At the end of each row, i would
like to have a cell to calculate all of my "V"'s, "S"'s, etc. HELP?