isna & if functions
 

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

isna & if functions
 

What formula(e) are you using? Does the column contain #N/A as a result of a
formula: if so, it is best to eliminate the #N/A condition i.e set cell to 0
or blank.

"Lisa" wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

isna & if functions
 

Thanks for the quick response.

I was using If(ISNA. Anyway, the #N/A is within a pivot. I know I can change
the #N/A to 0, but I was looking to do it in a separate formula. I've seen
it, I just can't seem to recreate it.

Thanks!

"Toppers" wrote:

What formula(e) are you using? Does the column contain #N/A as a result of a
formula: if so, it is best to eliminate the #N/A condition i.e set cell to 0
or blank.

"Lisa" wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

isna & if functions
 

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson

isna & if functions
 

You're the best. Thanks so much. Curiosity, why do you have to hit the
cntl+shift+enter key with arrays?

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson

isna & if functions
 

It's a way to tell excel to treat the formula as an array formula.

(not much better than 'cause you do!, huh?)



Lisa wrote:

You're the best. Thanks so much. Curiosity, why do you have to hit the
cntl+shift+enter key with arrays?

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson


--

Dave Peterson

isna & if functions
 

Thanks so much. I really appreciate your help on this. :-)

"Dave Peterson" wrote:

It's a way to tell excel to treat the formula as an array formula.

(not much better than 'cause you do!, huh?)



Lisa wrote:

You're the best. Thanks so much. Curiosity, why do you have to hit the
cntl+shift+enter key with arrays?

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson


--

Dave Peterson

isna & if functions
 

Well, if you can't learn if you don't ask questions. <vbg

Now, if you could only get some real answers, everything would be perfekt.



Lisa wrote:

Thanks so much. I really appreciate your help on this. :-)

"Dave Peterson" wrote:

It's a way to tell excel to treat the formula as an array formula.

(not much better than 'cause you do!, huh?)



Lisa wrote:

You're the best. Thanks so much. Curiosity, why do you have to hit the
cntl+shift+enter key with arrays?

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

isna & if functions
 

Well, you can't learn if you don't ask questions. <vbg

(stupid fingers)

Dave Peterson wrote:

Well, if you can't learn if you don't ask questions. <vbg

Now, if you could only get some real answers, everything would be perfekt.

Lisa wrote:

Thanks so much. I really appreciate your help on this. :-)

"Dave Peterson" wrote:

It's a way to tell excel to treat the formula as an array formula.

(not much better than 'cause you do!, huh?)



Lisa wrote:

You're the best. Thanks so much. Curiosity, why do you have to hit the
cntl+shift+enter key with arrays?

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.



Lisa wrote:

I'm trying to add a column of numbers; however, it contains #N/A. Don't think
I got the logic correct. Can anyone help me?

Thanks,
Lisa

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

--

Dave Peterson