Summing a Range With N/A's
 

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

Summing a Range With N/A's
 

How about this array

Paste formula into cell then press Ctrl + shift + enter

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553268

Summing a Range With N/A's
 

Many thanks Noob - that seems to have do the trick


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=553268

Summing a Range With N/A's
 

=SUMIF(AA5:AA350,"<#N/A")

Vaya con Dios,
Chuck, CABGx3



"SamuelT" wrote:


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