Tabulating letters over time

[kdunn44107]

My boss has set up a monthly calendar with 31 date columns and 1
monthly rows. Entered into the boxes, he wants V's, S's, and dashes.
He wants to add up the total number of V's and put the total number o
V's in the vacation column at the end of the row - same for the S's fo
sick time and the dashes for regular time off in column 32, 33, and 34.
Is this possible, and if it is, how do we do it?

(Basically, is there a way to automatically tabulate letters over
period of time and get a total number at the end?

 

[Guest]

In column 32, put in the formula:
=COUNTIF(A2:AE2,"V")
It will give the number of V's. Here this is for the row 2.

similarly, in column 33 and 34, put in
=COUNTIF(A2:AE2,"S") will give the number of S's
=COUNTIF(A2:AE2,"-") will give the number of -'s

This function counts a cell only if it same as the string specified in the
formula.

Warm Regards,
OfficeGuru