# VLookup returning Sum of several columns

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