Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
VLOOKUP and ISNA functions | Excel Worksheet Functions |