sum column with na from v lookup
On Sat, 19 Aug 2006 05:35:01 -0700, DERICKSON
wrote:
The column I am trying to sum contains the formula
=VLOOKUP(B620,'S:\Accounting\Donna\SAP Go Live\[Go Live Inventory Download
080806 Rec to 1550 081706 dje.xls]1550 not loaded final'!$B$3:$F$125,5,FALSE)
Is there a Sum Formula I can write that excludes the #N/A values which are
showing in the column as a result of the vlookup? I would like to find a sum
function so that I do not have to use the auto filter on my large spreadsheet
and the sort it would require.
Donna
Try wrapping your lookup formulae in an If(Iserror) formula.
i.e.
=IF(ISERROR(Vlookup(yourextremelylongformula)),0,V lookup(yourextremelylongformula))
Then you won't have any #N/As and a Sum will work fine.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|