Hi,
I'm having some trouble with a COUNTIFS formula. I'm basically trying to do a count of the number of "Bugs" that were "Done" within a date range (1 week period), across a year period. I'm using the following formula which is referencing data in another tab called RAW DATA:
=COUNTIFS('RAW DATA'!A$2:A$999,"Bug", 'RAW DATA'!H$2:H$999, "Done", 'RAW DATA'!L$2:L$999, ">=19/10/2020", 'RAW DATA'!L$2:L$999, "<=25/10/2020")
This formula seems to work and correctly counts the number of bugs for this particular week. However, I now want to drag that formula down for 1 years worth of data (for example). Is there a way I can do this so that I don't have to manually fill out the dates for every single week? I can't seem to find a way to make it work.
Thanks for the help
Bookmarks