I am trying to sum amounts based on two conditions. The information below is
a sample of what my spreadsheet looks like:

Line Groupings Data
Per1

Line 11 - 1# 1# Bottle Total Shifts Available
528
Line 11 - 1# 1# Bottle Total Shifts Required
69
Line 11 - 1# 1# Bottle Total Shifts Remaining -
Constrained 459
Line 14 - 2# FS 2# FS Bottle (Ln14) Total Shifts Available
528
Line 14 - 2# FS 2# FS Bottle (Ln14) Total Shifts Required
25
Line 14 - 2# FS 2# FS Bottle (Ln14) Total Shifts Remaining -
Constrained 503


I would like to sum the amounts from Per1 (Period 1) based on Grouping and
Data. I will also be using this formula to add more columns such as Per2 &
Per3 that are in columns E and F.

I have tried the following formula, but am not having success.

=SUMPRODUCT(--($B$2:$B$239=B2,--($C$2:$C$239="Total Shifts
Required"),$D$2:$D$239)


Any help would be appreciated.

Thanks,

Anne