Forum Discussion
Counting within a date range across multiple sheets?
Hi Excel community, I am working on creating a section within my grant tracking that shows us application rate per year. Until now we have mostly cared about our disbursements, but a new board wants ...
Hard to know what you are doing for sure but if you want to COUNT 'Disbursements' and ADD COUNT 'CityA' then you need to have them separate. As it is it will only COUNT if the row on sheet Disbursements is in the year 2023 AND the CORRESPONDING row on sheet 'CityA' is in the year 2023. Maybe you want this instead:
=COUNTIFS('Disbursements'!K:K,">=01/01/2023",'Disbursements'!K:K,"<=12/31/2023") + COUNTIFS('CityA'!G:G,">=01/01/2023",'CityA'!G:G,"<=12/31/2023")