Thread: multiple text criteria sum if function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
datasorter datasorter is offline
external usenet poster
  
Posts: 7
Default multiple text criteria sum if function
can anyone tell me whats wrong with this formula and how to fix it?

=sumif(and('[Upsell Monthly Report.xls]COB'!$A:$A,'[Upsell Monthly
Report.xls]COB'!$C:$C),(A8,B8),('[Upsell Monthly Report.xls]COB'!$I:$I)
Reply With QuoteReply With Quote