COUNTA copy down column

New Contributor



I am using COUNTA to give me a number for a specific range A2:A96. Is there a way that when I copy the formula down a column for it to change the range to the next n number of rows? Each 95 rows of the data set represents another user and I am trying to calculate the number of non blank rows for each user. So ideally it would be like COUNTA(A2:A96) then COUNTA(A97:A191) and so on. 



2 Replies
best response confirmed by athakore (New Contributor)


Let's say the first formula is in cell D3. Change the formula to




and fill or copy down.

thank you so much. I was trying to play around with offset but could not get it to work. This worked perfectly.