Forum Discussion
Auto Sum Errors
I have tried every I know to insert the full sheet & to then copy & paste, nothing worked. Sorry
PTO Balance
=SUM(A2:A29 This field to the left had a PTO Balance also but the formula was written over the
numbers in the field when I clicked AutoSum after highlighting the entire
column of numbers expecting the total to be added to the 1st empty field at
the bottom of the list. Nothing appeared there.
I'm sorry I could not send you the entire worksheet.
skluin Hi everyone,
I also ran into this problem. I have been using Excel extensively since the day it was released for the first time. I decided that the downloaded data I was using for some reason included a tag or other identifier which interfered with the Autosum function (I tried all the tricks) even though the data looked like it was formatted correctly. In other words, I had the option to download it as an excel worksheet. Didn't work. I went back to my data source and downloaded a CSV file instead and then pasted the data into my Excel worksheet using Paste Special>Values and Formats. I was able to filter the data and use the AutoSum function without any issues. So frustrating. My download source was QBO (good ole QBO, lots of quirky issues that they have had YEARS to fix and never have.)
Me too! I recently created a new version of my annual home-made bookkeeping spreadsheet - I have many clients and bill them and insurance companies weekly. My very simple worksheet for adding up each client's payments isn't working! I've checked that the format for all cells is Currency, and have been using autosum to add up these darn columns.
