I have been working on a spreadsheet where I need to count the number of
occurrences dependent on two criteria. Here is my situation
time blocks
0:22 2
0:15 1
0:35 1
I need to sum the number of times that a time of greater than 20 min time is
recored for a single (1) block. In my above example I should get 2. I
worked w/ countif and sumproducts but I am going wrong somewhere. Any
suggestions?