Is there a way to compare the numerical value of a year (i.e. "2015") to the year of a date (10/12/15)?
I have a column (col. C) on a different worksheet with a bunch of dates and I would like to sum the corresponding values in Col. V that match a particular year entered in cell (H2). Unfortunately, the year entered will only be the numerical representation of that year, not an actual date.
Here is the formula I'm trying (I've highlighted the portion I need help with):
=SUM(IF(AND($H$2=YEAR(Calcs!$C$5:$C$4244),MONTH(Calcs!$C$5:$C$4244)=2),Calcs!$V$5:$V$4244))
Thanks in advance.
Bookmarks