Forum Discussion
Formula repeating when dragging down
Hi all, When I drag my formula down, it is repeating the same formula (ie referencing the same cells as in the first row) rather than referencing the appropriate cells for the row. ...
AlexJamieson Try this in D2 and copy down:
=COUNTIFS($A$2:$A$31,">="&C2,$A$2:$A$31,"<"&C3)