Parts of formula disappear when I try to change arguments or ranges within a formula

[dawid2526]

Hello,

I've been having this annoying problem and it's been driving me crazy.

Each time I try to replace part of an argument in a formula, or the whole argument, or reference to a range, some parts of the rest of the formula that follow the change, just disappear.

For example,
=IF(G2="all",COUNTIFS(Master[[RAG rating ]],"R",Master[Open/Closed],"Open",Master[Lead Service],G3),COUNTIFS(Master[[RAG rating ]],"R",Master[Open/Closed],"open",Master[LA],G2,Master[Lead Service],G3))

Let's say I want to replace Master[Lead Service],G3 with a different criterion - Master[Case manager],G4 - when I do that chunks of what follows would disappear - in this case - COUNTIFS will be gone.

I am using Excel 2007 and work with data formatted as table.

Please help

Thank you.

[JohnTopley]

Are you using Find/Replace? works OK with me.

[dawid2526]

I've been trying to do that in the formula bar - it would be much easier if I could do that there.

[JohnTopley]

The only reason I can think that part of the formula would disappear is it inadvertently highlighted when you did the change. I never experienced your proble other via my own "finger trouble"!

If you have many rows to change FIND/REPLACE is obviously much better