Jan 27 2022 02:12 PM
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!
Jan 27 2022 02:50 PM
Jan 28 2022 12:57 AM
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.