| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I sum numbersin a column, when I also have #N/A in same co
|
|
#2
|
|||
|
|||
|
Hi
you may post your message as body of your post. But I'd guess you want something like =SUMIF(A1:A100,"<#NA") -- Regards Frank Kabel Frankfurt, Germany "Tucson Guy" schrieb im Newsbeitrag ... |
|
#3
|
|||
|
|||
|
"Tucson Guy" wrote: Thanks for trying Frank, but it came up with "Value" error message. Any other thoughts? Thanks |
|
#4
|
|||
|
|||
|
How about:
=SUM(IF(ISNUMBER(A1:A100),A1:A100)) 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.) Change the range, but not to the whole column. Tucson Guy wrote: "Tucson Guy" wrote: Thanks for trying Frank, but it came up with "Value" error message. Any other thoughts? Thanks -- Dave Peterson |
|
#5
|
|||
|
|||
|
Dave, It worked perfectly. Thank you very much. Richard "Dave Peterson" wrote: How about: =SUM(IF(ISNUMBER(A1:A100),A1:A100)) 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.) Change the range, but not to the whole column. Tucson Guy wrote: "Tucson Guy" wrote: Thanks for trying Frank, but it came up with "Value" error message. Any other thoughts? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
