Thread: If two criteria match then sum matching values in another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diddy Diddy is offline
external usenet poster
  
Posts: 155
Default If two criteria match then sum matching values in another column
Hi everyone,

What I would like to be able to do is sum the values in column L when value
in column C = N2 and in Column F = 1

I'm using the formula below but it's returning a value error

=SUMPRODUCT(--($C$2:$C$10000=$N$2),--($F$2:$F$100="1"),$L$2:$L$1000)

Any suggestions appreciated

Thanks
Reply With QuoteReply With Quote