Greetings,
I am now stuck trying to figure out a complex spreadsheet created by an
ex employee. If I click on Cell D34, I see the following in the formula bar
(while the cell appears empty):

{=SUM(IF(A50:A105=$D3,C50:C105))}

If I click on the formula in the formula bar to change from A105 to A120,
the
{} braces disappear and the formula appears in cell D34. Even if I retype
the
{} it still shows in the cell.

what is this and how do I change the formula while still having the cell
appear empty ?

thanks,
Darryl

This is an array formula, and you get it by committing the formula with
Ctrl-Shift-Enter instead of just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Darryl" wrote in message
...
Greetings,
I am now stuck trying to figure out a complex spreadsheet created by an
ex employee. If I click on Cell D34, I see the following in the formula
bar
(while the cell appears empty):

{=SUM(IF(A50:A105=$D3,C50:C105))}

If I click on the formula in the formula bar to change from A105 to A120,
the
{} braces disappear and the formula appears in cell D34. Even if I retype
the
{} it still shows in the cell.

what is this and how do I change the formula while still having the cell
appear empty ?

thanks,
Darryl