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:
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.=COUNTIFS(Sheet1!AM:AM,"0",Data!K:K,"Accepted")
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!
Bookmarks