# SUM IF Formula

#### ryan_law2000

##### Well-known Member
Hey Everyone here is the formula i have now

Code:
``=SUMIF(\$A\$1:\$A\$479,"Packers",C\$1:C\$479)``

I need to add another factore into this but im not to sure how

First search "Packers" in Range A1:A479
then look for "Brooks" in Range B1:B479
then sum the totals together in range C1:C479

Any ideas???

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Try

=SUMPRODUCT(--(A1:A479="Packers"),--(B1:B479="Brooks"),C1:C479)

Hi, you can use the SUMPRODUCT formula:
=SUMPRODUCT((\$A\$1:\$A\$479="Packers")*(\$B\$1:\$B\$479="Brooks")*\$C\$1:\$C\$479)

Perfect! Thanks

Replies
2
Views
239
Replies
5
Views
470
Replies
6
Views
235
Replies
10
Views
304
Replies
1
Views
143

1,207,095
Messages
6,076,552
Members
446,213
Latest member
bettigb

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