Thread: Count value in range, but exclude based on adjacent value.
View Single Post
  #4   Report Post  
amacrab amacrab is offline
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Spencer101 View Post
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.
Always amazed at how much excellent help you can get on these forums. Thank you!
Reply With QuoteReply With Quote