Excel removes parenthesis when editing formula

[tima26hotmailcom]

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 then it just changes the formatting to text. FYI-the formula totals up an assigned number (in a table) for each text value (in a table) within a data range.

[#2 · Accepted solution]

@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.

[#3]

@tima26hotmailcom 

Perfect Thx