Thread: Count value in range, but exclude based on adjacent value.
View Single Post
  #3   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by amacrab View Post
Attachment added

Have a look at the attached. I've included a SUMPRODUCT and a SUMIFS approach for this. The SUMIFS one will only work in Excel 2007 or later.
Attached Files
File Type: zip amacrab example.zip (5.5 KB, 58 views)
Reply With QuoteReply With Quote