Hi,

With your data in A1:A3, enter this formula into your total cell:

=SUM(COUNTIF(A1:A3,"A")*8+COUNTIF(A1:A3,"B")*10+CO UNTIF(A1:A3,"C")*12)

Ewan.

"Mullet2262" wrote:

Hi, I'm creating a roster, using the values "A" "B" and "C" for the different
shifts and I would like to be able to give each value the numerical value of
however many hours each shift is, without making the text in the cell change
to a number, but still be able to add up the number of hours at the end of
the line. In other words A = 8, B = 10, C = 12 and the total is 30. Hope
this makes sense. I am using MS Excel 2002. Many thanks! Mullet2262