Sumif

[mcmuney]

I'm currently using this formula, which works: =SUMIF($C$4:$O$4,"M",C9:O9) but I'd like to introduce a second criteria, but not sure how to go about it. I want to basically combine these two into one:

=SUMIF($C$4:$O$4,"M",C9:O9)
=SUMIF($C$8:$O$8,"MI",C9:O9)

I want the formula to sum if both criteria are true.

Thanks.

[NBVC]

Try

=Sumproduct(--($C$4:$O$4="M"),--($C$8:$O$8,"MI"),C9:O9)