View Single Post
  #1   Report Post  
Lee
 
Posts: n/a
Default Count with 2 conditions?

My data is in the following format

A B
1 2
1 0
2 0

I want to count how often there is a "1" in column A and a corresponding 2
(in the same row) in colum B

Thanks