Thread: SUMPRODUCT - 2 Criteria
View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
  
Posts: 247
Default SUMPRODUCT - 2 Criteria
Hi Teethless mama,

Apologies, I forgot that I'd conditionally formatted Column "I" to hide
errors. The #NUM error was hidden away.

Cheers,
Sam

Teethless mama wrote:
=IF(ISERROR(I5:I41),0,SUMPRODUCT(--(H5:H41="102/2"),--(I5:I410)))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1

Reply With QuoteReply With Quote