How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Computer Specialist
Category: Computer
Satisfied Customers: 36777
Experience:  Over 20 years of consulting to the IT industry
Type Your Computer Question Here...
Richard is online now
A new question is answered every 9 seconds

My sum command no longer functions...sum=(a1:An) will not

Customer Question

My sum command no longer functions...sum=(a1:An) will not sum (in dollars US)
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
Thanks for your question. My name is ***** ***** I look forward to assisting you.
If you do a normal sum such as =A1+B1
Does this work?
Customer: replied 2 years ago.
Simple summations do not work. I tried a new work sheet and upgraded Office but no success.
Customer: replied 2 years ago.
The cells are formatted for US currency and does not function. I am trying to do simple summations.
I'm using a MAC BookPro with OSX 10.10.4 with Office 2011.
Customer: replied 2 years ago.
RU there? See above e-mail
Expert:  Richard replied 2 years ago.
Sorry it wqs a few days before you replied and I was not online.
Sounds like auto calculation is disabled.
In excel go to preferences.> calculate and set to Automatic
Should then work
I can also do these steps for you, and have made a request via Additional Services. This is optional, and if you choose to do this, I can, with your permission, remote into your computer while you watch and do all these steps (and deal with any problems that arise during them) for you. Or if you do not choose to take this service, we can continue here. This is no problem at all. Just let me know please.
Let me know the results please