Thread: SumIf
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default SumIf
Biff wrote:
So how would we handle the OR of the two conditions using SUMPRODUCT.

=SUMPRODUCT(--((A1:A100="xyz")+(B1:B100="")0),C1:C100)

Klunk! Thanks.

Reply With QuoteReply With Quote