How to change cells based upon a another cell

Attach a sample Excel workbook, rather than a picture of one, by following the guidelines in the yellow banner at the top of the screen.

Pete

My apologies, I have attached one now.

I'm not sure about the numbers (through the formulae) that you have in AE3 to AG3 - I think this formula in AE3:

=SUMIFS($G$3:$AD$3,$G$2:$AD$2,">="&DATE(AE$2,1,1),$G$2:$AD$2,"<="&DATE(AE$2,12,31))*80

which can also be copied across into AF3:AG3, will give you a more accurate figure for each year of your table. I'll look at the other formulae after I've had confirmation from you.

Hope this helps.

Pete

Your sum can just be a sumproduct along the lines of =SUMPRODUCT((YEAR($G$2:$AD$2)=AE$2)*($G3:$AD3))*80

h2 is better as =EDATE(G2,1)

Hi Pete,

Thank you for catching that error. I had not changed the cells in AE3 to match the dates and the formula there was incorrect. Thank you very much for this formula, it works great.

Thanks,
Rachel

Hi,

Thank you very much for this formula, it works great.

Thanks,
Rachel