| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum array with #N/A
Hi,
For some reason I can't get the following to work. I have got an array of numbers in which some observations are #N/A (the equivalent of NA() ). 3 6 8 #N/A 4 #N/A 5 Normally I'd just sum this array by submitting {=SUM(A1:A7*ISNUMBER(A1:A7))}, but the (arrayed) formula returns #N/A. What do I need to do in order for the formula to return the value 26? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Working with array equations | Excel Discussion (Misc queries) | |||
| Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
