Date Ranges - 2 formulas needed

[excelteam777]

WS attached

1st: SALES T3 is where formula needs to go. I want SALES T6:1005 sum into T3 whenever
The dates in P6:1005 fall within the date range entered on SALES Y3 and Z3

2nd: Same formula just different cells
SALES U3 is where formula needs to go. I want SALES U6:1005 sum into U3 whenever
The dates in P6:1005 fall within the date range entered on SALES Y4 and Z4

[Glenn Kennedy]

Part 1
=SUMIFS($T$6:$T$1005,$P$6:$P$1005,">="&$Y$3,$P$6:$P$1005,"<="&$Z$3)

and part 2:
=SUMIFS($U$6:$U$1005,$P$6:$P$1005,">="&$Y$3,$P$6:$P$1005,"<="&$Z$3)

[63falcondude]

T3 =sumifs(t6:t1005,p6:p1005,">="&y3,p6:p1005,"<="&z3)

u3 =sumifs(u6:u1005,p6:p1005,">="&y3,p6:p1005,"<="&z3)

[excelteam777]

thanks, i am posting a new one shortly.

I had to make one change to your formula. part 2 was configred to Y3-Z3 instead of Y4-Z4 so i changed it and it works fine. thanks again.

[63falcondude]

Glad we could help. Thanks for the rep!