SUM IF Formula

[ryan_law2000]

Hey Everyone here is the formula i have now

=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???

 

[VoG]

Try

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

 

[tony80]

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

 

[ryan_law2000]

Perfect! Thanks

 

[shemayisroel]

ryan_law,

The below white paper should help you with SUMPRODUCT solutions

http://www.xldynamic.com/source/xld.SUMPRODUCT.html