# Sum IF MULTIPLE CRITERIA

#### davidhall80

##### Well-known Member
Sort of like the previous sumproduct question, but with addition.

Column A Has Zone 1 through Zone 9. Column B has "New", "Change", or "Old". Column C has hours worked. I would like to get total Hours Worked for "Zone 2" "New" assignments. If column A = Zone 2, and Column B = New, Than Sum Up Column C. Make sense??....Thanks in advance

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### NBVC

##### Well-known Member
Try

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

#### davidhall80

##### Well-known Member
If it's just addition, why is the sumproduct fuction used?

#### NBVC

##### Well-known Member
The result of the first 2 arguments in the formula will be arrays of 1's and 0's depending on if the criteria are matched or not, each set of 1's and 0's are then multiplied by the corresponding number in column C.....so C gets multiplied by 1 or 0 (the end result either the value in C or a 0) and then all these products get summed to give the final result.

Replies
12
Views
910
Replies
9
Views
488
Replies
4
Views
688
Replies
1
Views
661
Replies
3
Views
1K

1,172,019
Messages
5,878,759
Members
433,370
Latest member
mcleven

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