getting a total for a row of cells where some are text

[babs]

I am trying to get a total monthly salary for employess in the row however
some of the cells could contain a variety of text, ex. laid off, vacation,
off - it could possibly even be something different. My formula right now
is =c6+g6+k6+o6+s6 - obviously for the rows with text in one of the cells I
get Value? for the total. I would like to be able to keep the text in the
individual cells but handle the text as a 0 in the formula- once again it
could be any text- not always similar text.

Please help,
Thanks,
Babs

[Gary''s Student]

This trick can be applied to any collection of cells. In the simpliest case
say we want to add A1 and B1. Usually:

=A1+B1

will work just fine. If there may be extraneous text in either cell use:

=IF(ISNUMBER(A1),A1,0)+IF(ISNUMBER(B1),B1,0)

You can adapt this for your range of cells
Have a good day

--
Gary's Student


"babs" wrote:

> I am trying to get a total monthly salary for employess in the row however
> some of the cells could contain a variety of text, ex. laid off, vacation,
> off - it could possibly even be something different. My formula right now
> is =c6+g6+k6+o6+s6 - obviously for the rows with text in one of the cells I
> get Value? for the total. I would like to be able to keep the text in the
> individual cells but handle the text as a 0 in the formula- once again it
> could be any text- not always similar text.
>
> Please help,
> Thanks,
> Babs