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 Joe-S Your Own Question

Joe-S
Joe-S, Systems Specialist
Category: Laptop
Satisfied Customers: 129
Experience:  Systems Administrator at Fortune 50 Company
68269981
Type Your Laptop Question Here...
Joe-S is online now
A new question is answered every 9 seconds

On xl when I sum numbers it shows value what am I doing

Customer Question

On xl when I sum numbers it shows value what am I doing wrong
Submitted: 1 year ago.
Category: Laptop
Expert:  Joe-S replied 1 year ago.

Hi, my name is ***** ***** I'll be helping you today.

Here's a few things to consider:

  • One or more cells that are included in a formula contain text, and your formula performs math on those cells by using the standard arithmetic operators (+, -, *, and /).

    For example, the formula =A1+B1, where A1 contains the string "Hello" and B1 contains the number 3, returns the #VALUE! error.

  • A formula that uses a math function, such as SUM, PRODUCT, or QUOTIENT, contains an argument that is a text string instead of a number.

    For example, the formula PRODUCT(3,"Hello") returns the #VALUE! error because the PRODUCT function requires numbers as arguments.

  • Your workbook uses a data connection, and that connection is unavailable.

Would you consider uploading your spreadsheet so I can take a look at it?

Expert:  Joe-S replied 1 year ago.

I have not seen a response from you. Did this answer your question?

And please remember to rate my service. We receive no compensation unless you rate us as 3 stars or higher.