Formula has become text

[smithgt]

I have a strange problem today on one of my sheets using the =COUNTIFS function.

Basically I've created this formula,

=SUM(COUNTIFS('Tracker Calls All'!B:B,"TB",'Tracker Calls All'!J:J,"Awaiting Response")+COUNTIFS('Tracker Calls All'!B:B,"TB",'Tracker Calls All'!J:J,"Ready for Testing")+COUNTIFS('Tracker Calls All'!B:B,"TB",'Tracker Calls All'!J:J,"Awaiting Signoff"))

but when I've copied this to adjacent cells and tried to edit some of the values, the formula has become text.

All I've tried to do is change a users initials from TB to DL or GS

What have I done wrong?

thanks

 

[VoG]

Try formatting the cells as General then copy the formulas again.

 

[smithgt]

Thanks - that's worked.

It seems that after each edit I have to set the cell back to General.

How very strange!