Thread: how do I count pairs of cells when each matches a condition?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard pile
 
Posts: n/a
Default how do I count pairs of cells when each matches a condition?
I want to count the number of instances where 2 separate conditions are each
met e.g. the number of times when column A has a value of "x" AND column B
simultaneously has a value of "y" (actually one would be a numerical value
and one text). I am getting confused looking at the help section for array
formulae.
Help?!
Reply With QuoteReply With Quote