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 Jess M. Your Own Question
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6710
Experience:  Computer Software Specialist for more than 10 years
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

My Sum function no longer functions! =SUM(A1:An) returns

Customer Question

My Sum function no longer functions! =SUM(A1:An) returns $0.00 and not the sum of the quantities in the respective cells. I tried =sum(A1,A2,An) and it returns the same answer.
I upgraded from Office 2004 to 2011 someo, sameo. I'm running A MACBook PRO with OSX 10.10.4
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jess M. replied 1 year ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you please tell me the last cell in column A that you want to include in the SUM formula?

Please let me know so that I can help you further.

Best regards,

Related Microsoft Office Questions