Excel formula or Vba to Sum of all lookup value from multiple excelsheet

Question

I need some help for the below scenario,

Sheet1 A2 has a date
Sheet2 and Sheet3 has dates in column A and numbers in column B

example as below, enter image description here

I want to get the sum value from Sheet2 & Sheet3 B column for all the values in Sheet1 A2 if finds in Sheet2 & Sheet3 A.

Below is my formula which I can get the sum from Sheet2 but not able to do with both sheet2 and sheet3.

{=SUM((Sheet2!$B$2:$B$65500)*(Sheet2!$A$2:$A$65500='Sheet1'!A2))}

Please help in formula or vba, thanks

Dan Donoghue · Accepted Answer · 2015-04-23 05:10:40Z

1

Can't you just add the two?

In B2 of sheet 1

=SUMIF(Sheet2!A:A,A2,Sheet2!B:B)+SUMIF(Sheet3!A:A,A2,Sheet3!B:B)

answered Apr 23, 2015 at 5:10

Dan Donoghue

6,2662 gold badges20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chito Over a year ago

Damn! It is so simple and I never thought of it. Thanks a lot @Dan Donoghue

Dan Donoghue Over a year ago

Happy to help, I cannot count the number of times I have spent time on a problem that was relatively simple, it's hard not to overthink things sometimes :)

Collectives™ on Stack Overflow

Excel formula or Vba to Sum of all lookup value from multiple excelsheet

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related