CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-sheets-query
chappers
chappers

Reputation: 466

Google Sheets formula to calculate total sum of values in from multiple columns in another sheet

I need a formula for cell B2 in Sheet1 which will calculate the total value of column B in Sheet2 where the value of column A in Sheet2 matches any URL's in columns C to E in Sheet1.

For example B2 in Sheet1 would total 43 (32 + 9 + 2 from B2 + B4 + B6 in Sheet2), B3 would total 4, B5 would total 4 etc etc.

Note: Sheet1 may sometimes have URL's in

Sheet1

enter image description here

Sheet2

enter image description here

Upvotes: 0

Views: 98

Answers (1)

player0
player0

Reputation: 1

paste in Sheet1!B2 and drag down:

=SUM(ARRAYFORMULA(IFERROR(VLOOKUP(TRANSPOSE(C2:2), Sheet2!A$2:B, 2, 0))))

0

Upvotes: 1

Related Questions