# SUMPRODUCT beginner needs help!

#### rdmssean

##### New Member
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!

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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))

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!

Replies
0
Views
254
Replies
2
Views
251
Replies
1
Views
678
Replies
4
Views
342
Replies
6
Views
278

1,220,954
Messages
6,157,043
Members
451,394
Latest member
indrajeet_rajput

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back