Thread: multiple range in SUM,IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
  
Posts: 699
Default multiple range in SUM,IF
=SUM(IF(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531<=93),('1 3b'!F3:F75),""))

Im above array formula, 3rd criteria i am trying to set range 31 AND <=93
but it doesnt work .. could anyone help ??
Reply With QuoteReply With Quote