# 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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Andrew Poulsom

##### MrExcel MVP
Something like:

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

#### davidhall80

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

Replies
5
Views
314
Replies
16
Views
294
Replies
3
Views
494
Replies
1
Views
366
Replies
4
Views
2K

1,141,681
Messages
5,707,796
Members
421,528
Latest member
datdude151

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