Thread: SUMIF???
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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.