Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


2627 posts

Uber Geek
+1 received by user: 185


Topic # 192039 24-Feb-2016 23:49
Send private message

Hey guys.

 

Im sure the answer is simple, I cant for the life of me remebemr how to do it, even though I learnt years ago.

 

How can I add multiple cells without typing out every single cell? Example I want to add everything from A1-A10. Instead of going A1+A2+A3 etc, whats the easier/faster solution?

 

Thanks!


Filter this topic showing only the reply marked as answer Create new topic
930 posts

Ultimate Geek
+1 received by user: 404

Trusted
Subscriber

  Reply # 1498894 24-Feb-2016 23:55
2 people support this post
Send private message

Use the SUM function:

 

 

 

https://support.office.com/en-us/article/SUM-function-043E1C7D-7726-4E80-8F32-07B23E057F89






Doesn't know what he doin
2881 posts

Uber Geek
+1 received by user: 374

Subscriber

  Reply # 1498925 25-Feb-2016 07:18
Send private message

=SUM(A1:A10)

 

 

 

 





Bachelor of Computing Systems (2015)

 

--

 

Late 2013 MacBook Pro with Retina Display (4GB/2.4GHz i5/128GB SSD) - HP DV6 (8GB/2.8GHz i7/120GB SSD + 750GB HDD)
iPhone 6S + (64GB/Gold/Vodafone NZ) - Xperia Z C6603 (16GB/White/Spark NZ)

Sam, Auckland 


2474 posts

Uber Geek
+1 received by user: 674


  Reply # 1498933 25-Feb-2016 07:43
Send private message

Even just type the equal sign and then click/drag the set... It ""adds the "sum" for you by default now :)

To add multiple separate blocks, type equals and the n hold ctrl while clicking any seperated blocks needing adding (this works well for totals that aren't alligned)

6666 posts

Uber Geek
+1 received by user: 568

Trusted

  Reply # 1498938 25-Feb-2016 08:10
Send private message

Summage for the win it look like smile


3282 posts

Uber Geek
+1 received by user: 208

Trusted

  Reply # 1499093 25-Feb-2016 12:45
Send private message

Depending on your requirements, you might want to use the SUBTOTAL function. For example, =SUBTOTAL(109, A1:A10) will sum (that's the 9 in 109) the range A1:A10 excluding any manually hidden rows (that's the 100 in the 109). SUBTOTAL always excludes filtered rows.


Filter this topic showing only the reply marked as answer Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Intel introduces new NUC kits and NUC mini PCs
Posted 16-Aug-2018 11:03


The Warehouse leaps into the AI future with Google
Posted 15-Aug-2018 17:56


Targus set sights on enterprise and consumer growth in New Zealand
Posted 13-Aug-2018 13:47


Huawei to distribute nova 3i in New Zealand
Posted 9-Aug-2018 16:23


Home robot Vector to be available in New Zealand stores
Posted 9-Aug-2018 14:47


Panasonic announces new 2018 OLED TV line up
Posted 7-Aug-2018 16:38


Kordia completes first live 4K TV broadcast
Posted 1-Aug-2018 13:00


Schools get safer and smarter internet with Managed Network Upgrade
Posted 30-Jul-2018 20:01


DNC wants a safer .nz in the coming year
Posted 26-Jul-2018 16:08


Auldhouse becomes an AWS Authorised Training Delivery Partner in New Zealand
Posted 26-Jul-2018 15:55


Rakuten Kobo launches Kobo Clara HD entry level reader
Posted 26-Jul-2018 15:44


Kiwi team reaches semi-finals at the Microsoft Imagine Cup
Posted 26-Jul-2018 15:38


KidsCan App to Help Kiwi Children in Need
Posted 26-Jul-2018 15:32


FUJIFILM announces new high-performance lenses
Posted 24-Jul-2018 14:57


New FUJIFILM XF10 introduces square mode for Instagram sharing
Posted 24-Jul-2018 14:44



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.