Are sum cells possible with letters instead of numbers?

[Zesty]

I'm familiar with writing basic numeric formulas but is it possible to write an equation which takes into account representative letters? I'm producing a time sheet for work. The table has a row per day of the week and one of the columns records P for present, A for absent, H for holiday and N for Not working. I would like to total the number of times each of these letters appears in the column so that I can summarise at the end of the week that there have been x days holiday taken, x days absence etc. Is this possible? Thanks for any help in advance.

[dogberry]

Hi

Usue your countif function ie countif(a1:a25,"P)

Chris

[Teethless mama]

Take a look COUNTIF() in help menu

[oeldere]

@dogberry

countif(a1:a25,"P")

@Zesty

Or post an excel example, without confidentional info.

[dogberry]

[QUOTE=oeldere;3068759]@dogberry

countif(a1:a25,"P")

Thanks Oeldere if you know of anyone that has a keyboard that can spell and correct my mis typing Im interested


Chris

[Zesty]

Thanks all! Obviously a bit of a novice so appreciate the help