When I bring up the formula box for the following formula (attempting to sum
up numbers in a different sheet given various conditions) --

=SUM(IF(Sheet1!F2:F1900='1340 - 001'!B8,IF(Sheet1!D2:D1900='1340 -
001'!C8,IF(Sheet1!C2:C1900='1340 - 001'!F8,IF(Sheet1!G2:G1900='1340 -
001'!G6,Sheet1!J2:J1900,0),0),0),0))

it shows 'Formula Result'=69, which is correct, that's what it should be.
But in the cell itself, it will only show 0. I have this problem with most
complex formulas. In a related note, complicated formulas in old
spreadsheets work but if I go in there and say, erase a number and then put
it back, it has the same problem as above. Help!!