Results 1 to 4 of 4

Sum multiple columns using the same vlookup formula

This is a discussion on Sum multiple columns using the same vlookup formula within the Excel Questions forums, part of the Question Forums category; I am trying to use a vlookup to sum multiple columns of data all in the same row. I'm trying ...

  1. #1
    New Member
    Join Date
    Jun 2005
    Posts
    12

    Default Sum multiple columns using the same vlookup formula

    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!

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    14,056

    Default Re: Sum multiple columns using the same vlookup formula

    Try...

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

    Hope this helps!

  3. #3
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,644

    Default Re: Sum multiple columns using the same vlookup formula

    Hello,

    when entering the formula you need to press CTRL, SHIFT and ENTER.
    -------------------------
    Hope this is helpful.
    -------------------------
    only a drafter,
    but broadening my Excel knowledge.

  4. #4
    New Member
    Join Date
    Jun 2005
    Posts
    12

    Default Re: Sum multiple columns using the same vlookup formula

    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.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com