formula returning incorrect blanks
 

Problem:

When I enter the following equation into a cell with a blank in cell
CH12 or CH13 I get the correct answer (the sum of the cells with
numbers in them) but when there is a blank in cell CH14 I get an
incorrect answer (in the form of a clank cell).

=IF(AND(ISNUMBER(CH12:CH14)),SUM(CH12:CH14),"")

Does anyone have any suggestions?

Thanks,
Elaine

formula returning incorrect blanks
 

in case anyone has a similar problem, I got this suggestion from Dave
Peterson and it works perfectly!

=if(count(sh12:ch14)0,sum(ch12:ch14),"")


the 0 can be replaced with whatever number you want before a summation

is done (i.e. 1 value, 2 values, etc. present)

formula returning incorrect blanks
 

in case anyone has a similar problem, I got this suggestion from Dave
Peterson and it works perfectly!

=if(count(sh12:ch14)0,sum(ch12:ch14),"")


the 0 can be replaced with whatever number you want before a summation

is done (i.e. 1 value, 2 values, etc. present)

formula returning incorrect blanks
 

Michelle,

I have a clarifying question - why not just use SUM(CH12:CH14)? This will
sum the numbers and ignore the blanks.

Doug

wrote in message
ups.com...
Problem:

When I enter the following equation into a cell with a blank in cell
CH12 or CH13 I get the correct answer (the sum of the cells with
numbers in them) but when there is a blank in cell CH14 I get an
incorrect answer (in the form of a clank cell).

=IF(AND(ISNUMBER(CH12:CH14)),SUM(CH12:CH14),"")

Does anyone have any suggestions?

Thanks,
Elaine

formula returning incorrect blanks
 

You've got a couple of active threads elsewhere.

wrote:

Problem:

When I enter the following equation into a cell with a blank in cell
CH12 or CH13 I get the correct answer (the sum of the cells with
numbers in them) but when there is a blank in cell CH14 I get an
incorrect answer (in the form of a clank cell).

=IF(AND(ISNUMBER(CH12:CH14)),SUM(CH12:CH14),"")

Does anyone have any suggestions?

Thanks,
Elaine

--

Dave Peterson

formula returning incorrect blanks
 

That makes sense.

Doug

wrote in message
oups.com...
in case anyone has a similar problem, I got this suggestion from Dave
Peterson and it works perfectly!

=if(count(sh12:ch14)0,sum(ch12:ch14),"")


the 0 can be replaced with whatever number you want before a summation

is done (i.e. 1 value, 2 values, etc. present)