I'm trying to count the number of positively valued cells in a list that are followed by a positively valued cell (and again and again, etc.).
My best guess as to how I would do this is to do a CountIfS using the range with one cell removed from the bottom, and the same range, starting one cell down.
Ex. I want to see how many times there are two adjacent positive numbers in 1, 1, -1, 1, -1
=CountIfs(A1:A4, ">0", A2:A5, ">0")
However, the list is filtered, which screws up my counts. My research has led me to think that the Subtotal function is the usual fix, but this does not seem to accommodate using multiple criteria (in other words, it provides count if, not count ifs). Any ideas?
Bookmarks