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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the COUNTA function 1
Excel Typed text appears in wrong cell 0
Getting Text data using the Data - Subtotal feature 1
cell totals 4
excel 2007 - how to insert row with formats and totals of previous 1
Formula to return text 1
Max Length in a row 1
Adjusting row height to accomidate text in a cell 2

Back
Top