title: Excel formulas giving #VALUE! error when ported to Mac
body: <p>I want to be able to sum up the number of cells in a range that have a non-null value in them. On a PC running XP and Excel I entered <code>=SUM(IF(G$19:G$1034="",0,1))</code> and it spit out the correct answer. Now the same spreadsheet on a Mac running Excel 2004 for Mac gives that a <code>#VALUE!</code> error. Any thoughts on why?</p>