wackybadger
New Member
- Joined
- Jan 5, 2019
- Messages
- 2
I am trying to count the number of dates that fall within certain months/years in a large range with a majority of blank cells (to be filled in the future). The data comprises nearly 700 rows and 35 columns and I would like to count the # of dates in every month from January 2009 to January 2019 and beyond. The data is contained in cells from AK6:BR699. I've tried various versions of SUMPRODUCT such as:
=SUMPRODUCT((MONTH(AK6:BR699)=AS732)*(YEAR(AK6:AK699)=AR733)) where AS732 and AS733 contain the month and year of interest, respectively, but due to all of the blank cells, I get #VALUE !. Any suggestions?
=SUMPRODUCT((MONTH(AK6:BR699)=AS732)*(YEAR(AK6:AK699)=AR733)) where AS732 and AS733 contain the month and year of interest, respectively, but due to all of the blank cells, I get #VALUE !. Any suggestions?