title: Using COUNTIF down a column instead of across rows for multiple rounds
body: <p>I have a large amount of data set up in the form of rounds. I need to count down the 'Round' column while counting if '1' occurs in the 'Prediction' column. I know how to do this manually but I have over 200 rounds I need to account for. I'd like to just drag across COUNTIFS(C2:C11, 1) but Excel assumes I want the same cells in the next row (D2:D11) instead of the next group down the column (C12:C21). I'd like to a way to tell it to do something like COUNTIF(x+1:y+1, 1), but down a column.</p>
  
  <p><a href="https://i.stack.imgur.com/pTvYQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pTvYQ.png" alt="sample of data"></a></p>