Thread: If and nested Sumif error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default If and nested Sumif error
TRY
=IF(J175<3,SUMPRODUCT((J2:J175=3)*(F2:G175)))

Reply With QuoteReply With Quote