Forum Discussion
Solved
Excel removes parenthesis when editing formula
Hi, When I edit the formula below Excel removes the parenthesis {} & then the formula doesn't work. {=SUM(SUMIFS(Tables!$G$3:$G$7,Tables!$F$3:$F$7,Data!K7:Z7))} If I add them in manually ...
tima26hotmailcom Indeed. When you edit a formula that is enclosed in curly brackets you need to confirm it with Ctrl-Shift-Enter. The the curly brackets will be included again.
tima26hotmailcom Indeed. When you edit a formula that is enclosed in curly brackets you need to confirm it with Ctrl-Shift-Enter. The the curly brackets will be included again.