Vlookup+sumif?

[dtham292]

Good Morning All,

I need to return total deposit on specific date to a different tab.

I need when I enter date in Tab #1 A6, in B6 I get the total in I from Tab#2 by Date entered in Tab#2 J (So total should be in Tab#1 B6 $3,321.00).


Tab#1


Tab#2


Thank you so much!

 

[AhoyNC]

My antivirus software will not allow me to see your data, but is there some reason you can't just use SUMIF as in the example below.
I'm assuming your dates are actual Excel dates and not text. Let us know if they are text.

Excel Workbook
	A	B
6	5/5/2019	614.25
Tab1

Excel Workbook
	A	B
1	Date	Amount
2	4/25/2019	107.00
3	4/25/2019	131.00
4	4/25/2019	106.00
5	5/1/2019	135.00
6	5/5/2019	343.25
7	5/4/2019	130.00
8	5/1/2019	219.00
9	5/5/2019	271.00
10	5/6/2019	126.00
11	5/1/2019	293.00
Ta2