Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NA error
Hi,
i am auto summing on a range of cells. soome of the cells do not have figures in yet but do have formulas that return #NA at the moment. How do I ignore those cells until they have data in and only count the cells with figures i.e 1 1 #N/A #N/A #N/A #N/A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NA error
With these values in A2:A7
1 1 #N/A #N/A #N/A #N/A If the only errors in the range are #N/A, this formula ignores those returns the total: A8: =SUMIF(A2:A7,"<#N/A") Does that help? *********** Regards, Ron XL2003, WinXP "Mark R" wrote: Hi, i am auto summing on a range of cells. soome of the cells do not have figures in yet but do have formulas that return #NA at the moment. How do I ignore those cells until they have data in and only count the cells with figures i.e 1 1 #N/A #N/A #N/A #N/A |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NA error
=SUM(IF(ISNUMBER(A1:A10),A1:A10))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mark R" wrote in message ... Hi, i am auto summing on a range of cells. soome of the cells do not have figures in yet but do have formulas that return #NA at the moment. How do I ignore those cells until they have data in and only count the cells with figures i.e 1 1 #N/A #N/A #N/A #N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |