Thread: Help with SUMIF and criteria
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John[_60_] John[_60_] is offline
external usenet poster
  
Posts: 16
Default Help with SUMIF and criteria
Frank, thanks a bunch for your help! Your suggestion seems to work just fine.
-John


=SUM(OFFSET(B2,0,MATCH(TRUE,B2:M20,0)-1,1,3))
enter this as array formula (CTRL+SHIFT+ENTER)
Reply With QuoteReply With Quote