Solved

Google Sheet Formula

Posted on 2016-08-29
2
77 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
[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
2 Comments
 
LVL 18

Accepted Solution

by:
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

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

Featured Post

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many of you may be aware of the recent Google Docs scam emails that have been floating around coming from various people that you know. Here's a guide on identifying How To Identify the Scam Email You will see an email from someone you’ve had co…
This Micro Tutorial demonstrates in Google Analytics how to create a custom report that shows you traffic over time using the month of year dimensions. There are also instructions on how to fix Google's odd month of year formatting, which Microsoft …
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

627 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