# SUMPRODUCT IF

#### davidhall80

##### Well-known Member
I know how to do a SUMIF, but is it possible to do a sumproduct if. In column A, I have Zones 1-9. I want a formula that says.....

If a cell in column a = "Zone 2", than multiply the adjacent cell in column B with the adacent cell in column C. And then add all those products together. I'm trying to get Total Gross Pay for Zone 2. Column B is my Payrate, Column C is my Hours worked. Make sense??? I hope I explained this correctly. Thanks in advance!!!

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### Andrew Poulsom

##### MrExcel MVP
Something like:

=SUMPRODUCT(--(A1:A100="Zone 2"),B1:B100,C1:C100)

#### davidhall80

##### Well-known Member
Thanks...it worked

Replies
9
Views
227
Replies
3
Views
112
Replies
2
Views
133
Replies
7
Views
172
Replies
2
Views
133

1,181,079
Messages
5,927,968
Members
436,580
Latest member
ajoshi76

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