| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum a range of data (column) that has #num! in some cells
I have columns of data that I need to sum. Some of these cells have #NUM! in
them. How would I sum these columns? Thanks in advance for your ideas... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum a range of data (column) that has #num! in some cells
=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. steve_sr2 wrote: I have columns of data that I need to sum. Some of these cells have #NUM! in them. How would I sum these columns? Thanks in advance for your ideas... -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum a range of data (column) that has #num! in some c
Thanks alot...works great...
"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. steve_sr2 wrote: I have columns of data that I need to sum. Some of these cells have #NUM! in them. How would I sum these columns? Thanks in advance for your ideas... -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| making the range a set of data within a column | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Hybrid Mode
