Jacob,
Thanks for the fast response.
I have to admit to not understanding your explanation of what I need to do.
I did copy and paste the suggested, changed formula and, what happened?
The cell I was trying to change simply reverted to the previous formula -
that is, it reverted to a replication of the cell above!
--
Geoff


"Jacob Skaria" wrote:

If you have selected a range and array entered...To edit or remove you will
need to select the same range and edit the formula in active cell and array
enter again(Ctrl+Enter)

This is not an answer to your query. You can rewrite your formula as a
non-array one

=SUMPRODUCT((Purchases!$F$2:$F$5000="Goldman
Sachs")*(Purchases!$D$2:$D$5000=DATE(2004,4,29)), Purchases!$I$2:$I$5000)

If this post helps click Yes
---------------
Jacob Skaria


"Geoff Newham" wrote:

Hi,
This has been particulary galling and it's not the first time, either!
I had this message: "Can't change part of an array". It popped up while
dealing with some corrections to a sheet. I was left with no option but to
ctrl+alt+delete to end the task since I could not click on any part of the
sheet or other worksheets nor could I even delete the sheet or worksbook and
most functions are greyed out.

The formula was ={SUM(IF(Purchases!$F$2:$F$5000="Goldman
Sachs",IF(Purchases!$D$2:$D$5000=DATEVALUE("29/04/2004"),Purchases!$I$2:$I$5000,0),0))}.

Since I discovered that this actually replicated the cell above and should
have been analysing purchases via Investec, not Goldman Sachs, I changed the
formula to read Investec. This is one of 25 different brokers in a list where
each one analyses the purchases using the above formula.
The system baulked at the first change and so I deleted the whole formula to
re-write it, then the notice popped up.
Q1: If this notice pops up again, is there any way to back out of it
without losing everything?
Q2: What causes this notice to pop up? If I understand that, I can avoid
the cause.

Many thanks
Geoff