peterhinton
Active Member
- Joined
- Mar 8, 2016
- Messages
- 336
Morning All,
I have some data in column A like the below,
I want to sum this, however when I use =SUM(A:A) I get an error due to the #N/A,
How can I get around this,
I cant alter the data in column as its generated from a background query,
Sure there is a simple array formula to do this, any suggestions ?
<colgroup><col width="64" style="width: 48pt;">
<tbody>
</tbody>
I have some data in column A like the below,
I want to sum this, however when I use =SUM(A:A) I get an error due to the #N/A,
How can I get around this,
I cant alter the data in column as its generated from a background query,
Sure there is a simple array formula to do this, any suggestions ?
31666.67 |
44833.33 |
33666.67 |
33666.67 |
33666.67 |
9166.667 |
8083.333 |
8833.333 |
1000 |
9500 |
#N/A |