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

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