Adding up cells that include text in them
 

I have a time sheet where I want to add the last 3 characters in each of
the cells to get a grand total for the row.
Here's a sample:


WED THUR FRI SAT SUN TOTAL


N3 - 7.5 N3 - 7.5 N3 - 7.5 N3 - 7.5


If I treat the 5 columns as A to E, the total in cell F2 might be the
formula =value(right(A2,3))+value(right(B2,3))+value(right (C2,3))+value
(right(D2,3))+value(right(E2,3))

The problem is that the cell B2 (THUR) is blank so Excel interprets this as
an error. Can anyone offer me a formula that will work if it is blank? I
also will have a total of 14 cells to add (2 weeks) - this is just a
sample. It will also not do to place 0's in the empty cells - it's too
ugly.

TIA!

Alan

On Tue, 23 Aug 2005 22:45:22 GMT, Alan wrote:

I have a time sheet where I want to add the last 3 characters in each of
the cells to get a grand total for the row.
Here's a sample:


WED THUR FRI SAT SUN TOTAL


N3 - 7.5 N3 - 7.5 N3 - 7.5 N3 - 7.5


If I treat the 5 columns as A to E, the total in cell F2 might be the
formula =value(right(A2,3))+value(right(B2,3))+value(right (C2,3))+value
(right(D2,3))+value(right(E2,3))

The problem is that the cell B2 (THUR) is blank so Excel interprets this as
an error. Can anyone offer me a formula that will work if it is blank? I
also will have a total of 14 cells to add (2 weeks) - this is just a
sample. It will also not do to place 0's in the empty cells - it's too
ugly.

TIA!

Alan

See the answer to the identical question you posted about 20 minutes earlier
than this one!



--ron