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, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30208
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

what is correct way to write a sum formula which needs info

This answer was rated:

what is correct way to write a 'sum' formula which needs info from another worksheet in the
same spreadsheet? I was trying: "=sum('Dec 2012'!)'Dec 2012'l5:l8" in a spreadsheet that contains worksheets Jan 2013, Feb 2013, and so on. Note: the double quotes " " above are not in my formula.
You need to do it like this

=sim(dec 2010!A1)

It would reference A1 in that sheet

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Customer: replied 3 years ago.

got a #NAME? response from excel

Hi Jim

Download this example I did for you

A1 on sheet1 shows the formula.

Let me know if you have any difficulties please

Thank you
Customer: replied 3 years ago.

that is how I set the formula, but when I hit 'enter', the formula changes to

include another Dec 2012 like so: =sum(Dec 2012!)'Dec 2012'l5:l8 and then asks me which worksheet to use, and then when I select worksheet

and hit enter, up pops the #NAME?

Can I look at your worksheet please Jim?

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"


Customer: replied 3 years ago.

file id is 917718

works ok for me Jim

Which cells are you trying to Sum?

And where do you want to display the results?

Customer: replied 3 years ago.

in Jan 2013, cell L5, I am trying to put total of Dec 2012, L5:L8

This is done Jim, and you can download it here

File ID: 178920

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Customer: replied 3 years ago.

Thanks for your help.....I don't understand why the last formula you wrote has a space where the ! was before....can you explain?

The editor puts it in Jim, spaces have no bearing in formulas (Excel will correct them).

Feel free to ask if you would like more information please

Thank you

Richard and other Microsoft Office Specialists are ready to help you