# figuring

1. ### Sumproduct vertical vs Horizontal

Hello again, I having trouble figuring out how to use sumproduct formula vertical vs horizontal. I have this formula =SUMPRODUCT((a1:d6=LEGEND!\$D\$4:\$D\$7)*(LEGEND!\$E\$4:\$E\$7)) what I need is =SUMPRODUCT((a1:a6=LEGEND!\$D\$4:\$D\$7)*(LEGEND!\$E\$4:\$E\$7)) can anyone assist please... because when I...
2. ### Getting cells that arent in order to reference cells in order.

I hope the title makes sense. So I have a ref list on another sheet that I have cells to refer to but my cells aren't in order for example my first cell that refers to the list is in B2 and the next one is in B18. I'm figuring it has something to do with the offset function but I cant figure it...

### 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