Sum by Multiple criteria and date range

[lmcghee]

Hello!
I'm trying to do a sum based on Employee ID, Date Range and amount. I've messed around with index/match, sumif imbedded in an If, and other random formulas. I just can't get it to work. I'm overthinking it and I'm sure it is so very simple.

Help!

Sheet 1:
Where I'm putting the formula (F6)
Date Range: G2:G3

Sheet 2: where I'm pulling the info from.
Column D: employee ID
Column O: Amount
Column S: Date

 

[Fluff]

How about

=SUMIFS(Sheet2!O:O,Sheet2!D:D,A6,Sheet2!S:S,">="&G2,Sheet2!S:S,"<="&G3)

 

[lmcghee]

=SUMIFS(Sheet2!O:O,Sheet2!D:D,A6,Sheet2!S:S,">="&G2,Sheet2!S:S,"<="&G3)

Perfect!! thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[lmcghee]

You're welcome & thanks for the feedback.

Can you help me with one more? Similar scenario

Results: Sheet 1, E6, pulled from Sheet 2

What I want:
Lookup: Employee ID sheet 1 = employee ID sheet 2, within the date range (sheet 1 G2,G3), give me the first result in Column T.

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[lmcghee]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

Updated. Office 365 MSO 32 bit

 

[Fluff]

Ok how about

=INDEX(FILTER(Sheet2!T2:T100,(Sheet2!D2:D100=A6)*(Sheet2!S2:S100>=G2)*(Sheet2!S2:S100<=G3)),1)

 

[lmcghee]

Ok how about

=INDEX(FILTER(Sheet2!T2:T100,(Sheet2!D2:D100=A6)*(Sheet2!S2:S100>=G2)*(Sheet2!S2:S100<=G3)),1)

Perfect!! thank you so much

 

[Fluff]

My pleasure.