Basic Excel question

Forums › Microsoft Windows › Basic Excel question - Need Help

Finch

2862 posts

Uber Geek
+1 received by user: 195

#192039 24-Feb-2016 23:49

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!

Brumfondl

1198 posts

Uber Geek
+1 received by user: 524

Trusted

Subscriber

#1498894 24-Feb-2016 23:55

Use the SUM function:

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

tardtasticx

3084 posts

Uber Geek
+1 received by user: 483

#1498925 25-Feb-2016 07:18

=SUM(A1:A10)

PhantomNVD

2619 posts

Uber Geek
+1 received by user: 759
Inactive user

#1498933 25-Feb-2016 07:43

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)

Jaxson

8172 posts

Uber Geek
+1 received by user: 1332

Trusted

#1498938 25-Feb-2016 08:10

Summage for the win it look like

bazzer

3438 posts

Uber Geek
+1 received by user: 267

Trusted

#1499093 25-Feb-2016 12:45

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.