J
Jerry
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.
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.