I'd like to perform the product function for cells in the rows that contain the year 2016. I tried the following code but it just returns FALSE. My thinking: if the year of the date in column A contains "2016", then multiply the corresponding cells in column A for these rows. Any suggestions?


=IF(ISNUMBER(SEARCH(2016,YEAR(A25:A336))),(PRODUCT(C$25:C$336+1)-1),"FALSE")
Thanks!