SUMPRODUCT beginner needs help!

[rdmssean]

I have the following multiple-condition sumproduct formula setup:

=SUMPRODUCT((YR=$C$3)*(PD=$C$4)*(WK=H$9)*(GL=$B13))*(AMT)

YR, PD, WK, GL, and AMT are all named ranges of data.

All of the named ranges are of equal size (from rows 12 through 21).

There are no empty cells, all cells in the ranges contain data.

My issue is that the formula works for WK=H$9=1 but when I copy it over to my next column where I would like it to find the sum for WK=K$9=2, the formula still returns the value as if the trigger was 1 (not 2). My range for WK has 1's and 2's and I've confirmed all other conditions seem to be working.

Hopefully that makes sense....forgive me but I'm a beginner with sumproduct!

Thanks in advance for your help!!

 

[jim may]

Remove the below RED ")"

=SUMPRODUCT((YR=$C$3)*(PD=$C$4)*(WK=H$9)*(GL=$B13))*(AMT)

and try this.......

=SUMPRODUCT((YR=$C$3)*(PD=$C$4)*(WK=H$9)*(GL=$B13)*(AMT))

 

[rdmssean]

Remove the below RED ")"

=SUMPRODUCT((YR=$C$3)*(PD=$C$4)*(WK=H$9)*(GL=$B13))*(AMT)

and try this.......

=SUMPRODUCT((YR=$C$3)*(PD=$C$4)*(WK=H$9)*(GL=$B13)*(AMT))

Brilliant!!! This did the trick. Thank you so much!