Formula Driving me crazy

%3CLINGO-SUB%20id%3D%22lingo-sub-2803599%22%20slang%3D%22en-US%22%3EFormula%20Driving%20me%20crazy%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2803599%22%20slang%3D%22en-US%22%3E%3CP%3EI%20entered%20a%20formula%20in%20one%20cell%20(a%20count%20if)%26nbsp%3B%20and%20it%20worked%20fine.%3C%2FP%3E%3CP%3EI%20copied%20it%20to%20another%20cell%20and%20changed%20one%20letter%2C%20and%20it%20won't%20work.%26nbsp%3B%20All%20it%20does%20is%20show%20the%20formula%2C%20not%20the%20result.%26nbsp%3B%20I%20tried%20entering%20from%20scratch%20and%20get%20the%20same%20result.%26nbsp%3B%20It%20must%20be%20something%20simple.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2803599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I entered a formula in one cell (a count if)  and it worked fine.

I copied it to another cell and changed one letter, and it won't work.  All it does is show the formula, not the result.  I tried entering from scratch and get the same result.  It must be something simple.

2 Replies

@Rick_Irvine make sure 'Show Formulas' isn't set on:

mtarler_0-1633110560207.png

 

Nope. I got it to work by retyping both formulas again and not using copy or formula wizard. Weird.