Solved

# Google Sheet Formula

Posted on 2016-08-29
72 Views
Hi,

Does anyone know how to add up the B3 and A5:A9 in the example attached.

As you can see, it's not working.

Please note, i will be expanding the range A5:A9 so i don't want to keep adding A5+A6+A7...

0
Question by:oo7ml
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 18

Accepted Solution

xtermie earned 500 total points
ID: 41774692
=sum(b3; A5:A9)
or
=sum(b3, A5:A9)
; or , to separate arguments depending on your regional settings

Also, use DATA --> Named Ranges to name your range (A5:A9) and then you can use the named range in the formula instead of the range itself; which means if you want to change it, you just change the named range reference instead of the formulas

=sum(B5, myrng)
0

LVL 7

Expert Comment

ID: 41774716
In Excel, =sum(a5:a9)+ b3 would do it
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Explore the encryption capabilities built into Google Apps and how these features can help you meet privacy policy and regulatory compliance, but are not a full solution. Understand and compare the most popular email encryption services for Google A…
If your app took Google’s lash recently, here are the 5 most likely reasons.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
###### Suggested Courses
Course of the Month5 days, 1 hour left to enroll

#### 739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.