Count current year in worksheet

Originally Posted by Vikas_Gautam

=SUMPRODUCT(--(iferror(YEAR(F15:F34)=YEAR(TODAY()),0)))

That needs to be array entered due to the IFERROR function.

Array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.