=SUMPRODUCT(--(YEAR(B2:B589)=2017))
=SUMPRODUCT(--(YEAR(B2:B589)=2018))
=SUMPRODUCT(--(YEAR(B2:B589)=2019))
I am using the code above to count based on a date in a continually expanding table.
If i expand the range beyond B589 it returns #VALUE regardless of data that is in the table and I'm...