Thread: SUMIF???
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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.