If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SUMIF???
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. |
#2
|
|||
|
|||
SUMIF???
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. |
#3
|
|||
|
|||
SUMIF???
=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. |
#4
|
|||
|
|||
SUMIF???
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. |
#5
|
|||
|
|||
SUMIF???
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. |
Thread Tools | |
Display Modes | |
|
|