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 The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1936
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Excel 2010 Home & Student. When using =SUM((b3:b39) formula

This answer was rated:

Excel 2010 Home & Student. When using =SUM((b3:b39) formula cell returns # XXXXX

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

let me know when you are ready to being

The-PC-Guy :

begin

Customer:

ready now

The-PC-Guy :

you have too many parenteses

The-PC-Guy :

change to

The-PC-Guy :

=SUM(b3:b39)

The-PC-Guy :

then it should work

Customer:

\\\that's what I am inputting in

The-PC-Guy :

do you get something like

The-PC-Guy :

#################

The-PC-Guy :

in the output?

Customer:

No, just one #

The-PC-Guy :

ok, i would need to see your worksheet

The-PC-Guy :

can you upload to www.wikisend.com

The-PC-Guy :

after uploading you will be given a download link

The-PC-Guy :

paste here

The-PC-Guy :

and i should be able to fix it

Customer:

Need help with this please

The-PC-Guy :

you can open another tab in your browser

The-PC-Guy :

and type

The-PC-Guy :

www.wikisend.com

The-PC-Guy :

into the addresss bar

The-PC-Guy :

then click upload tab

The-PC-Guy :

find the file

The-PC-Guy :

then upload it

The-PC-Guy :

after uploading you will be given a download link

The-PC-Guy :

and a file ID#

The-PC-Guy :

if you just type the file ID# XXXXX can access it

The-PC-Guy :

how is it going?

ok when you post the file ID# XXXXX will help you further
Customer: replied 4 years ago.

File should have gone to you.

sorry, I never got the file ID #

after you upload to the file to the wikisend website, wait about 30 seconds then the website will give you a file ID#

You then need to let me know what that number is XXXXX I can get the file.
Customer: replied 4 years ago.

I'll try again.

ok, i will be here
Customer: replied 4 years ago.

Did you receive it? Number 394846

ok I have a solution for you.

You can download from this link

http://wikisend.com/download/140768/Outgoings 2012_13-JA-MOD.xlsx

The problem was that you are using a custom format in the cell you had your formula in, that required the cell to be wider, much wider.

Excel defaults and puts # XXXXX place instead of numbers if the column is to short.

To prevent this just widen the column.

LaughingLaughingLaughingPLEASE DON'T FORGET TO RATE SO I GET PAID FOR MY TIME, BONUS IS ALSO APRECIATEDLaughingLaughingLaughing
The-PC-Guy and other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.

Many thanks

No problem, feel free to ask for me again in the future.

ask for The-PC-Guy

Related Microsoft Office Questions