Hi all,
I'm trying to SUM a range (AA5:AA350). However, the numbers have been
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 or
ISERROR, however I haven't been able to sort out the correct formula.
Can anyone help?
TIA,
SamuelT
--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread:
http://www.excelforum.com/showthread...hreadid=553268