Solved

Google Sheet Formula

Posted on 2016-08-29
2
44 Views
Last Modified: 2016-08-29
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...

google sheets
0
Comment
Question by:oo7ml
2 Comments
 
LVL 17

Accepted Solution

by:
xtermie earned 500 total points
Comment Utility
=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

by:tomfarrar
Comment Utility
In Excel, =sum(a5:a9)+ b3 would do it
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

There are many add-ons for Google docs, slides and sheets that can be extremely helpful in keeping your files organized and simple to use. Add-ons are installed into your Google docs, slides or sheets through Google's Add-On Store. One of my favorit…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

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

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

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now