Forum Discussion
marcinjudzinski
Jan 27, 2022Copper Contributor
Help finding a formula in Excel
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 Replies
- marcinjudzinskiCopper Contributor
grazie HansVogelaar!
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.