If/Then (For Rows in Column A containing year, multiply corresponding cells in Column C)

[TIfinance]

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!

 

[Mick Peters]

Not quite sure what you are trying to achieve with this but having broken the formula apart the fault seems to lay in that the Year() function only works on a single cell,

=IF(ISNUMBER(SEARCH(2016,YEAR(A1))),(PRODUCT(C$1:C$336+1)-1),"FALSE")

This said the product function then only has 1 value to work on. Depending on how large the range is you could either use other cells for your calculations. So a set of cells that work out the result of the corresponding C column to the A column and then use Product to do your calculation on those cells.

=IF(ISNUMBER(SEARCH(2016,YEAR(A1))),C1,0)

I hope this helps
If not please post some further detail.