Hi all, I am trying to find the number of dates in G1:C1 that equal the year of the cell in A1, but I am getting a value error. When I use this formula down columns rather than across rows, it seems to work fine. Is there a workaround to get this to work across rows?
=SUMPRODUCT(--(YEAR(G1:CM1)=YEAR(A1)))
=SUMPRODUCT(--(YEAR(G1:CM1)=YEAR(A1)))