I'm creating a spreadsheet for a computer applications class, and I'm stuck. I know how to add a column of numbers together using the 'auto sum' feature, but for some reason, on one of the rows it isn't working correctly. I'm highlighting the column, and I'm hitting autosum (and I'm adding together a bunch of larger numbers here) but the result is always just a zero. It's really making me mad! even when I enter the formula manually, it comes to zero! I can't figure out what I'm doing wrong! Are there any excel-savvy folks out there who know what I should do??
Yeah, I'm sure I'm selecting everything. I've got a theory though... everything works correctly in the columns that I entered just plain old numbers into manually. The problem comes up when I try adding together columns of numbers I got through formulas... What I mean (have to clarify, don't know if I'm making sense)... When I hit the 'show formulas' button, the columns of numbers I'm adding which are still just numbers that I physically typed in are fine. But the columns that are all =IMSUB(D4,E4) and whatnot, those are not working. I'm thinking I might have to change a setting or something... ugh, I hate this program. Heh.
Also, the numbers are all positive, and quite high, and I'm not using any decimals.