Creating periodic max values from daily values

Kindly help me fix this formula
=MAX(IF(YEAR($A$2:$A$104)=B2,IF($D$2:$D$104=D2,$E$2:$E$104))) + CSE

My data range (based on daily values) is for few years and I would like to get values
based on weekly, monthly, 3 month and 6 months.

I attach a sample file

Thank you.

In Column B (Year):

Formula:

Please Login or Register  to view this content.

and set format to "General".

Originally Posted by FDibbins

or just this...
=MAX(IF((YEAR($A$2:$A$104)=YEAR(B2))*($C$2:$C$104=C2),$E$2:$E$104))
you are pulling out the year from A, you need to do the same for B

Thank you for your help, but sorry, both your formula didn't work.

I have this non-array formula working

this gives me max for the month
=SUMPRODUCT(MAX(($A$2:$A$104=$B2)*($A$2:$A$104=$C2)*$E$2:$E$104))

this formula for weekly values ...doesn't work
=SUMPRODUCT(MAX(($A$2:$A$104=$B2)*($A$2:$A$104=$D2)*$E$2:$E$104))

how do I tweak the formula to get max values for 3 & 6 months

Please see the attached file.

Thank you.

Thank you FDibbins for your kind help. Happy with the sumproduct formula

Is it possible to display results once per month. Kindly see the attached file for what I mean.
Screenshot also attached...thank you so much. Happy holidays!