Thread: Count value in range, but exclude based on adjacent value.
View Single Post
  #1   Report Post  
amacrab amacrab is offline
Junior Member
  
Posts: 3
Default Count value in range, but exclude based on adjacent value.
Hi.

In the attached spreadsheet, is there any way to count the number of times "A" appears in column B, but exclude the times it appears next to "saf" in column A? So the answer should be 3, but how do you get there using a formula?

Thanks.
Last edited by amacrab : November 7th 12 at 12:11 PM Reason: clarification
Reply With QuoteReply With Quote