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 Benjamin Larson Your Own Question
Benjamin Larson
Benjamin Larson, Software Development Engineer
Category: Software
Satisfied Customers: 86
Experience:  Software Development Engineer
94796889
Type Your Software Question Here...
Benjamin Larson is online now
A new question is answered every 9 seconds

How do I add totals from sheets 1, 2, & 3 of the same

Customer Question

how do I add totals from sheets 1, 2, & 3 of the same spreadsheet
Submitted: 1 year ago.
Category: Software
Expert:  Benjamin Larson replied 1 year ago.

Hi, I'm Benjamin. Welcome to our site. I'm reviewing your question now and I'll reply with more details ASAP.

Expert:  Benjamin Larson replied 1 year ago.

I'm guessing you are using Excel - is that correct? If not, which program are you using? Also, which version please. I'm asking so I can give you the directions specific to your version.

Customer: replied 1 year ago.
Excel
Expert:  Benjamin Larson replied 1 year ago.

Awesome, which version? 2003, 2007? etc - also I'm assuming you are using Windows version, right?

Customer: replied 1 year ago.
windows 7
Expert:  Benjamin Larson replied 1 year ago.

Here's the general example if that's enough: "=SUM(Sheet2!A1,Sheet3!B2:B6)" this would add the values in cell A1 of Sheet2 to the values in B3 through B6 of Sheet3.

here's a link to a more detailed explanation: http://smallbusiness.chron.com/add-cells-across-multiple-spreadsheets-44275.html

Sorry if I was unclear - I was asking which version of Excel - 2007, 2013, etc.

If this information is enough to help you, awesome! In that case, I'd greatly appreciate a positive rating. If not, keep replying here until you get your answer and I'll keep helping and you can rate me at that point. :)

Expert:  Benjamin Larson replied 1 year ago.

Also, thanks for your quick responses :)

Expert:  Benjamin Larson replied 1 year ago.

Two more options for you - If you want me to remote into your computer or call you to walk you through it, but there is an extra charge for that since it's considered a premium service. No extra charge is needed for us to keep working together here.

In case a video helps you better than that link or explanation I provided: https://www.youtube.com/watch?v=gjmvpwPGzhQ

Expert:  Benjamin Larson replied 1 year ago.

Hi Frank, I was just wondering if you need any more help with your question?

If not, I would really appreciate a positive rating.

If you still need help, please let me know how I can further assist.

Thanks!

Expert:  Benjamin Larson replied 1 year ago.

Hi Frank.

If I solved your question, I would appreciate a positive rating - I'm only paid if I have gotten a positive rating on this question. If you don't feel I've provided value for that rating, please reply and I'll work to try to get your question answered. Thanks!