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: 70
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: 7 months ago.
Category: Software
Expert:  Benjamin Larson replied 7 months 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 7 months 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 7 months ago.
Excel
Expert:  Benjamin Larson replied 7 months ago.

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

Customer: replied 7 months ago.
windows 7
Expert:  Benjamin Larson replied 7 months 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 7 months ago.

Also, thanks for your quick responses :)

Expert:  Benjamin Larson replied 7 months 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 7 months 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 7 months 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!

Related Software Questions