Sum column based on date range

Hi

I'm looking for a formula in each of the yellow cells that sums the values in column E if the date above the highlighted cell fits into the range in that row.

i.e

Under 16/03/22, it would sum 3+8
Under 17/03/22, it would sum 3+4+8

I have found very similar examples but not quite the same and I have been unable to adapt.

Thanks for any help

Maybe like this:

=SUMIFS($E$5:$E$10,$C$5:$C$10,"<="&A$14,$D$5:$D$10,">="&A$14)

Solution:

Formula:

Please Login or Register  to view this content.

Thank you both, these both work brilliantly.

My mind better understands the first one, though I do need to learn how to use array formulas. Nonethless I managed to adapt both to my actual spreadsheet.

Another question - is it possible with either formula to easily ignore hidden (filtered) rows, or am I best adapting the sumifs formula with another condition?

SUMPRODUCT can deal with hidden rows, in the file attached I hided the last row.

Formula:

Please Login or Register  to view this content.