Thread: Multiple Columns in Sum Range using SUMIFS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
  
Posts: 151
Default Multiple Columns in Sum Range using SUMIFS
Try

SUMPRODUCT(('New Sales'!$N$11:$N$9999)*('New
Sales'!$E$11:$E$9999=$A$5)*('New
Sales'!$J$11:$J$9999=1))

HTH
Mick
Reply With QuoteReply With Quote