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.


    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:


    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
  • =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