Basically the same as your other question.

=COUNTIF(A1:A20,"H")


Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 08:22:02 -0700, Dave wrote:

Hi, I need to make a letter have a value, so I can then use auto sum to then
add up. I need the letter H to have the same valve as one, so I can use this
on an attendance sheet, so when some enters H, it will then be counted as
one. I can then see how many days someone has had off.

Thanks

Dave