I have two spreadsheets where in the first one I enter numbers for the week
throughout the month.  These values go from 1-1000.  Also accepted values for
these cells are text when no collection of values is done or when is excused.
For instance:
           week 1                        week2
c     g     k     o       s       w     aa    ae    ai     am
65  32  210  OPT  EXC    56    LV    10     32    40
I take the values of the 5 days and add them and put the total in another
summary spreadsheet.  The problem arises when the sum of these values picks
up the text and gives me a #value error.  What I want is that whenever it
encounters text in the computations it treats them as zeros thus bypassing
the error and giving me the total desired.  Thanks in advance.