I HAD A SIMPLE ADDITION FORMULA IN A CELL THAT WAS WORKING THE LAST TIME I WAS IN MY SPREADSHEET AND NOW WHEN I TRY TO CHANGE THE FORMULA WITHIN THAT SME CELL, IT KEEPS ADDING UP TO "0" NO MATTER WHAT NUMBERS OR FORMULA I PUT IN IT. HELP!
I do a simple formula in a cell, eg =SUM(A1*2), and it calculates correctly, however, when I grab the corner of that cell to drag it down to copy the formula, it just copies the same text in the cells, but the formula displayed for that cell is correct, but it doesnt = what the formula says