vlookup using Sum and "<>"

[mactoolsix]

I have a spreadsheet that I want to pull data from 5 different columns using SUM(VLOOKUP as an array. Problem some of the cells may be blank which leads to an #N/A error.

I attempted this: {=IFNA(SUM(VLOOKUP(AB8,'Cash Flow Detail '!B12:AN94,"<>",{24,26,31,33,39})),0)} however that returns a #NA ME? error.

Is there a simple way to accomplish this with writing out multiple vlookup statements and then adding them all together?

 

[Fluff]

What version of Xl are you using?
IFNA only started with 2013

 

[mactoolsix]

Ok that helps - I'm using excel 2010.

 

[Fluff]

In that case you'll probably need to use If with ISNA

 

[mactoolsix]

OK Thanks!

 

[Fluff]

You're welcome