Sum multiple columns using the same vlookup formula

[dubvie]

I am trying to use a vlookup to sum multiple columns of data all in the same row.

I'm trying to use
=SUM(VLOOKUP($A7,'2008 Monthly TEMP Pivot'!$A:$N,{4,5,6,7,8,9,10,11,12,13},FALSE))
to sum columns 4,5,6...

But it is giving me the same result as
=VLOOKUP($A7,'2008 Monthly TEMP Pivot'!$A:$N,4,FALSE)

Is there a way to do what I'm trying with out summing 10 different vlookups?

Thanks for any help/advice!

 

[Domenic]

Try...

=SUMPRODUCT(VLOOKUP($A7,'2008 Monthly TEMP Pivot'!$A:$N,{4,5,6,7,8,9,10,11,12,13},FALSE))

Hope this helps!

 

[onlyadrafter]

Hello,

when entering the formula you need to press CTRL, SHIFT and ENTER.

 

[dubvie]

Thank you only a drafter! It was that simple, I was not using ctrl+shift+enter.

Thank you for the alternate suggestion Domenic. It would've have worked as well.