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.


Finch

2862 posts

Uber Geek
+1 received by user: 195


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


Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

Brumfondl
1199 posts

Uber Geek
+1 received by user: 524

Trusted
Subscriber

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

Use the SUM function:

 

 

 

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






Create new topic








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.