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

2667 posts

Uber Geek

#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?



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

Uber Geek


  #1498894 24-Feb-2016 23:55
Send private message

Use the SUM function:

3016 posts

Uber Geek

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






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 


2601 posts

Uber Geek

  #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)

7070 posts

Uber Geek


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

Summage for the win it look like smile

3316 posts

Uber Geek


  #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 and LinkedIn »

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 »

Menulog change colours as parent company merges with Dutch food delivery service
Posted 2-Jul-2020 07:53

Techweek2020 goes digital to make it easier for Kiwis to connect and learn
Posted 2-Jul-2020 07:48

Catalyst Cloud launches new Solutions Hub to support their kiwi Partners and Customers
Posted 2-Jul-2020 07:44

Microsoft to help New Zealand job seekers acquire new digital skills needed for the COVID-19 economy
Posted 2-Jul-2020 07:41

Hewlett Packard Enterprise introduces new HPE GreenLake cloud services
Posted 24-Jun-2020 08:07

New cloud data protection services from Hewlett Packard Enterprise
Posted 24-Jun-2020 07:58

Hewlett Packard Enterprise unveils HPE Ezmeral, new software portfolio and brand
Posted 24-Jun-2020 07:10

Apple reveals new developer technologies to foster the next generation of apps
Posted 23-Jun-2020 15:30

Poly introduces solutions for Microsoft Teams Rooms
Posted 23-Jun-2020 15:14

Lenovo launches new ThinkPad P Series mobile workstations
Posted 23-Jun-2020 09:17

Lenovo brings Linux certification to ThinkPad and ThinkStation Workstation portfolio
Posted 23-Jun-2020 08:56

Apple introduces new features for iPhone iOS14 and iPadOS 14
Posted 23-Jun-2020 08:28

Apple announces Mac transition to Apple silicon
Posted 23-Jun-2020 08:18

OPPO A72 a top mid-tier smartphone
Posted 19-Jun-2020 18:02

D-Link A/NZ launches new smart AX1500 Wi-Fi 6 Router
Posted 19-Jun-2020 15:03

Geekzone Live »

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

Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron

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.