Help finding a formula in Excel

[marcinjudzinski]

Hi everyone, I'm looking for a formula that allows me to obtain the sums of the values of the same type present in columns once some cells of the corresponding rows are selected.

I am attaching the screenshot of my Excel file: how can I get the sums of the cells of the columns E:H in AX130: AX133 if I insert F in AX?

These summations must occur every time I insert F on the columns of the calendar that I am creating.

Thanks in advance for the help!

[#2]

@marcinjudzinski 

In AX130:

=SUMIF(M5:M129;"F";E5:E129)

In AX131:

=SUMIF(M5:M129;"F";F5:F129)

etc.

[#3]

grazie @Hans Vogelaar! 

The formula worked and I changed it in the final part by setting $ in the "E5: E129" field in order to drag the formula and fix that area.