SUMIF???

[ker1378]

I need a formula that will sum up columns N through W but only for rows where
column C = specific word AND F = specific word.

 

[Jacob Skaria]

Try
=SUMPRODUCT((C1:C100="a")*(F1:F100="b")*(N1:W100))

 

[Bob Phillips]

=SUMPRODUCT((C2:C200="word")*(F2:F200="other word")*(N2:W200))

 

[ker1378]

I tried both and am getting a "#VALUE!" error

 

[ker1378]

I take the last post back. I am all set now. Thank you!