SOLVED

New Contributor

# 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 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 Replies
best response confirmed by tima26hotmailcom (New Contributor)
Solution

# Re: Excel removes parenthesis when editing formula

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

Perfect Thx