C
Charlie G
I'm trying to copy formulas from one spreadsheet to another similar to the
one below, but the curly brackets disappear, rendering the formulas
inoperable (in the original document, they compare values in one range of
cells against another, count the cells that match as 1, and adds them up).
Adding the curly brackets manually just converts the cells to text. How do I
make these formulas work in the new document? I'm using Excel 2000. TIA.
~Charie G.
{=SUM(COUNTIF(B5:F5,$B$2:$F$2))}
one below, but the curly brackets disappear, rendering the formulas
inoperable (in the original document, they compare values in one range of
cells against another, count the cells that match as 1, and adds them up).
Adding the curly brackets manually just converts the cells to text. How do I
make these formulas work in the new document? I'm using Excel 2000. TIA.
~Charie G.
{=SUM(COUNTIF(B5:F5,$B$2:$F$2))}