Thread: SUMPRODUCT - 2 Criteria
View Single Post
  #3   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,

Thank you for reply and assistance. I get #NUM using the Formula. I'm not
sure if the blank cells and, or cells with "empty text" is causing this?

Further assistance appreciated.

Cheers,
Sam

Teethless mama wrote:
=SUMPRODUCT(--(H5:H41="102/2"),--(I5:I420))

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

Reply With QuoteReply With Quote