| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A and SUM
I have a table with numbers and #N/A.
5 10 #N/A 13 etc... when I try to sum all the numbers up I also get a #N/A. Is there a way Excel will sum all the numbers and disregard the #N/A? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#N/A and SUM
=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.) amirstal wrote: I have a table with numbers and #N/A. 5 10 #N/A 13 etc... when I try to sum all the numbers up I also get a #N/A. Is there a way Excel will sum all the numbers and disregard the #N/A? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#N/A and SUM
Thanks very much!
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#N/A and SUM
one mo
=SUMIF(A1:A10,"<#n/a") If your errors are only #n/a's. amirstal wrote: I have a table with numbers and #N/A. 5 10 #N/A 13 etc... when I try to sum all the numbers up I also get a #N/A. Is there a way Excel will sum all the numbers and disregard the #N/A? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
