I'm trying return a value in a range from the row that matches two separate conditions.

I tried to use this statement: =IF(AND(B2:B7="Tuesday",C2:C7="Shift 2",D2:D7,"")

Looking to return the value 11 in D6

A B C D
Row 2 Monday Shift 1 8
Row 3 Monday Shift 2 9
Row 4 Monday Shift 3 7
Row 5 Tuesday Shift 1 8
Row 6 Tuesday Shift 2 11
Row 7 Tuesday Shift 3 7


Am I close???