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.

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

--
Jacob


"ker1378" wrote:

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.

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

--

HTH

Bob

"ker1378" wrote in message
...
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.

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

"ker1378" wrote:

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.

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

"ker1378" wrote:

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.