none
VLookup returning Sum of several columns RRS feed

  • Question

  • Hi,

    How do I calculate a VLookup that returns the sum of multiple columns.

    ie. in the table below i want to lookup Sales and return the sum of the 3 weeks , 450.

    Weeks, w1, w2, w3

    Sales, 100, 150, 200

    I have been experimenting with the below idea but haven't managed to crack it yet.

    =VLOOKUP("Sales",'Sheet1'!A1:D2,COLUMN(B:D),FALSE)

    Does anyone have any ideas?


    • Edited by Gazza101 Friday, June 22, 2012 10:22 AM
    Friday, June 22, 2012 10:21 AM

All replies

  • Try Below:

    =SUM(VLOOKUP("Sales",A8:D8,COLUMN(B:D),FALSE))

    Note:It is Array Formula.So after pasting a cell press ctrl+shift+enter.

    ---------------------------------------------------------------------------------------------

    Please do not forget to click “Vote as Helpful” if any post helps you and mark as Answer if it solves the issue.


    Friday, June 22, 2012 10:58 AM
    Answerer
  • =SUMIF(Sheet1!A1:A11, "SALES", Sheet1!B1:B11)+SUMIF(Sheet1!A1:A11, "SALES", Sheet1!C1:C11)+SUMIF(Sheet1!A1:A11, "SALES", Sheet1!D1:D11)
    Tuesday, June 26, 2012 3:01 PM