On a PC running XP and Excel I entered SUM(IF(G19:G1034,0,1)) and it spit out the correct answer.

Excel 15.23 Why Won'T Formulas Work Mac Running Excel

Now the same spreadsheet on a Mac running Excel 2004 for Mac gives that a VALUE error.

Select the cell or range of cells that contains the array formula, press CONTROL U to edit the formula, and then press RETURN.

That, is the separator on one machine and something else, for example; is the separator character on the other.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel macos or ask your own question.

You will find below the steps to fix the issue of Formula Not Working in Excel.

However, the formulas are not producing any result and they are just being displayed as Text strings.

If the Formula is enclosed in quote marks, Excel will treat the Formula as a Text string.

Excel For Mac 15.23 Why Won'T Formulas Work