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