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

B

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
 
G

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
 
Top