Excel Autosum

[Dick7Access]

This is what I Googled at two different web sites.
Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula appears in cell B7, and Excel highlights the cells you’re totaling.
See attachment for error messafge. What gives?

 

[Darrell]

Hi there, any chance of attaching the workbook to verify the data / formatting etc, as it does indeed seem like a strange error.

 

[Deleted member 147267]

Maybe one or more of your values are formatted as text or coerced to text by an apostrophe? Are any of the values the result of a formula or are they simple values?
Have never seen that error before.

 

[Isaac]

Just type in the formula without using autosum. That would be the typical approach and might yield better results

 

[Dick7Access]

Just type in the formula without using autosum. That would be the typical approach and might yield better results

Thanks for answering, but I like to find out what I am doing wrong. It may help next time I screw up something else.

 

[Isaac]

can you attach the spreadsheet where you performed this action and got the error?

 

[Dick7Access]

can you attach the spreadsheet where you performed this action and got the error?

This new format sucks. I though I had send the spreadsheet the same day. Now I see it never was posted. I was wondering why there was no follow post. I will hunt it up again. It took me a lenth of time just to find this thread again.