Summing a Range With N/A's

S

SamuelT

Hi all,

I'm trying to SUM a range (AA5:AA350). However, the numbers have bee
generated via a VLOOKUP, and hence I've got a few N/A's dotted around
Seems that Excel doesn't like this - and returns an N/A result.

I suspect there's some means of doing the SUM with an added ISNA o
ISERROR, however I haven't been able to sort out the correct formula
Can anyone help?

TIA,

Samuel
 
V

VBA Noob

How about this array

Paste formula into cell then press Ctrl + shift + enter

=SUM(IF(ISERROR(AA5:AA350),"",AA5:AA350))
 
Top