Increase value in quotation marks in successive rows

I'm new to these forums. I've googled extensively but can't find the answer to my problem, so hoping someone here will be able to help!

I'm currently using the countifs function to help in a project as follows:

=COUNTIFS(Sheet1!AM:AM,"0",Data!K:K,"Accepted")

Where the number 0 here represents the number of days since the project started. With subsequent rows, I need this figure to increase by 1, all the way up to 365.

Unfortunately just dragging down doesn't change values within quotation marks. Does anyone know a way to solve this issue? I have several columns with similar formulae, so individually typing the values would take far too long!

Thank you in advance!

Thank you!

For some reason I thought it needed to be in quotation marks! Feel a bit silly, but your formula works perfect. 365 rows, and similar formulae for about 40 columns.

Thanks again