Excel Sum Function

SUM function is one of the most used function in MS Excel. This formula not only adds user defined values in a cell but also adds values from different cells. It is used in Excel 2013, 2010, 2007 and other versions of excel with same syntax.

Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.

The above shows you different examples. You can have numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.

158 thoughts on “Excel Sum Function

  1. I precisely needed to say thanks all over again. I do not know what I might have gone through in the absence of the strategies shared by you about that field. Previously it was a very alarming condition in my view, but understanding the expert tactic you handled the issue forced me to jump over fulfillment. Extremely happier for the information and then wish you find out what a powerful job you happen to be undertaking educating the rest thru your webblog. I know that you haven’t come across any of us.

  2. Hey there would you mind letting me know which web host you’re working with? I’ve loaded your blog in 3 different web browsers and I must say this blog loads a lot faster then most. Can you recommend a good web hosting provider at a reasonable price? Thank you, I appreciate it!|

  3. Good ¡V I should certainly pronounce, impressed with your site. I had no trouble navigating through all tabs as well as related info ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your client to communicate. Excellent task..

  4. As I site possessor I believe the content matter here is rattling magnificent , appreciate it for your efforts. You should keep it up forever! Good Luck.

  5. I like what you guys are up too. Such intelligent work and reporting! Keep up the superb works guys I’ve incorporated you guys to my blogroll. I think it’ll improve the value of my website :).

  6. Hi there! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no backup. Do you have any solutions to prevent hackers?|

  7. Very interesting details you have observed , appreciate it for posting . “I’ve made a couple of mistakes I’d like to do over.” by Jerry Coleman.

  8. Thank you, I have just been looking for information approximately this subject for ages and yours is the best I’ve found out so far. However, what in regards to the conclusion? Are you sure in regards to the supply?

  9. you are really a good webmaster. The site loading pace is incredible. It kind of feels that you’re doing any unique trick. Also, The contents are masterpiece. you have performed a magnificent job on this subject!|

  10. Hi! I could have sworn I’ve visited this site before but after browsing
    through many of the posts I realized it’s new to me. Anyhow, I’m definitely pleased I found it and I’ll be book-marking it and checking back frequently!

  11. I am not sure where you are getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for fantastic information I was looking for this information for my mission.

  12. It’s appropriate time to make some plans for the long run and it is time to be happy. I have learn this submit and if I may just I wish to counsel you few attention-grabbing issues or advice. Perhaps you could write next articles regarding this article. I want to learn more issues approximately it!|

  13. I am really inspired together with your writing abilities and also with the structure on your weblog. Is this a paid topic or did you customize it yourself? Either way stay up the nice quality writing, it is rare to look a nice weblog like this one these days..|

  14. Simply wish to say your article is as astonishing. The clarity in your post is just great and i can assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please carry on the enjoyable work.

  15. Have you ever thought about writing an ebook or guest authoring on other sites? I have a blog based upon on the same information you discuss and would really like to have you share some stories/information. I know my viewers would value your work. If you are even remotely interested, feel free to shoot me an e mail.|

  16. Just wish to say your article is as amazing. The clearness to your submit is just nice and i
    can think you are an expert in this subject. Fine together with your permission let
    me to take hold of your RSS feed to stay updated with forthcoming post.

    Thanks 1,000,000 and please carry on the gratifying work.

  17. You can definitely see your enthusiasm in the article you write. The arena hopes for even more passionate writers like you who aren’t afraid to say how they believe. All the time follow your heart.|

  18. Very interesting details you have remarked, regards for putting up. “The earth has music for those who listen.” by William Shakespeare.

  19. Thank you for sharing superb informations. Your web-site is very cool. I’m impressed by the details that you¡¦ve on this blog. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found just the info I already searched everywhere and simply could not come across. What a great website.

  20. I like the helpful info you supply to your articles. I will bookmark your weblog and check once more right here frequently. I’m somewhat certain I’ll learn a lot of new stuff right right here! Good luck for the following!|

  21. F*ckin’ tremendous things here. I’m very happy to see your article. Thanks so much and i’m taking a look ahead to touch you. Will you please drop me a e-mail?

  22. Wow! This can be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Actually Excellent. I am also a specialist in this topic so I can understand your hard work.

  23. Thank you for sharing excellent informations. Your web-site is so cool. I’m impressed by the details that you’ve on this website. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for more articles. You, my pal, ROCK! I found just the information I already searched all over the place and simply could not come across. What an ideal website.

  24. You actually make it seem so easy with your presentation but I find this topic to be actually something which I think I would never understand. It seems too complex and extremely broad for me. I’m looking forward for your next post, I will try to get the hang of it!

  25. Hi! I just wanted to ask if you ever have any
    problems with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of
    hard work due to no data backup. Do you have any methods to prevent
    hackers?

  26. Hello there! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!|

  27. You can definitely see your skills within the paintings you write. The world hopes for even more passionate writers such as you who are not afraid to mention how they believe. All the time follow your heart.

  28. Absolutely composed subject matter, thank you for selective information. “Life is God’s novel. Let him write it.” by Isaac Bashevis Singer.

  29. Your style is unique compared to other folks I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this page.|

  30. Hey there! I’ve been reading your web site for a long time now and finally got the courage to go ahead and give you a shout out from Humble Texas! Just wanted to mention keep up the good job!|

  31. Hello my family member! I want to say that this article is amazing, great written and come with almost all important infos. I would like to see more posts like this.

  32. Do you mind if I quote a few of your articles as long as I provide credit and sources back to your webpage? My blog site is in the exact same niche as yours and my visitors would really benefit from a lot of the information you provide here. Please let me know if this alright with you. Cheers!|

  33. Hello there! I just want to give you a big thumbs up for your excellent information you have got right here on this post. I am coming back to your website for more soon.|

  34. I blog quite often and I truly thank you for your content. Your article has really peaked my interest. I am going to bookmark your blog and keep checking for new details about once a week. I subscribed to your Feed too.|

  35. Today, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 25 foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is totally off topic but I had to share it with someone!|

  36. Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a little bit, but other than that, this is fantastic blog. An excellent read. I’ll certainly be back.

  37. Hi there! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success. If you know of any please share. Thanks!|

  38. I’m not that much of a internet reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back in the future. Cheers|

  39. You can definitely see your skills in the work you write. The sector hopes for more passionate writers like you who aren’t afraid to mention how they believe. At all times follow your heart.|

  40. Excellent blog here! Also your website loads up fast! What web host are you using? Can I get your affiliate link to your host? I wish my web site loaded up as fast as yours lol

  41. Howdy this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!|

  42. This is really interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your wonderful post. Also, I’ve shared your web site in my social networks!

  43. Spot on with this write-up, I absolutely believe
    this site needs much more attention. I’ll probably be returning to read more, thanks for the info!

  44. Thanks for ones marvelous posting! I seriously enjoyed reading it, you happen to be a great author. I will make certain to bookmark your blog and definitely will come back at some point. I want to encourage one to continue your great job, have a nice afternoon!|

  45. Have you ever considered publishing an e-book or guest authoring on other sites? I have a blog centered on the same topics you discuss and would really like to have you share some stories/information. I know my viewers would appreciate your work. If you’re even remotely interested, feel free to send me an e-mail.|

  46. Excellent blog here! Also your web site loads up fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as fast as yours lol

  47. What i don’t understood is in reality how you are not actually a lot more smartly-preferred than you may be right now. You’re very intelligent. You realize therefore significantly on the subject of this topic, made me personally imagine it from numerous varied angles. Its like women and men aren’t interested unless it is something to accomplish with Woman gaga! Your own stuffs great. At all times care for it up!|

  48. A person essentially assist to make seriously articles I’d state. That is the first time I frequented your website page and up to now? I surprised with the analysis you made to make this particular submit extraordinary. Great activity!

  49. Today, I went to the beach front with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!|

  50. You’re so interesting! I don’t believe I have read through anything like that before. So great to discover somebody with a few original thoughts on this issue. Really.. thanks for starting this up. This web site is one thing that’s needed on the web, someone with a bit of originality!|

  51. Definitely believe that which you stated. Your favorite justification seemed to be on the internet the easiest thing to be aware of. I say to you, I definitely get irked while people think about worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people could take a signal. Will likely be back to get more. Thanks

  52. I like the valuable information you provide in your articles. I will bookmark your blog and check again here regularly. I am quite certain I will learn lots of new stuff right here! Good luck for the next!

  53. Hi there, I do think your blog may be having internet browser compatibility issues. When I look at your web site in Safari, it looks fine however, if opening in IE, it has some overlapping issues. I simply wanted to give you a quick heads up! Other than that, great blog!|

  54. Undeniably believe that which you stated. Your favorite reason seemed to be on the internet the simplest thing to be aware of. I say to you, I definitely get irked while people think about worries that they just don’t know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thanks|

  55. Thank you for every other informative web site. The place else could I get that kind of information written in such a perfect manner? I have a mission that I am simply now running on, and I’ve been on the look out for such info.|

  56. Good day! This is my first comment here so I just wanted to give a quick shout out and say I truly enjoy reading your blog posts. Can you suggest any other blogs/websites/forums that cover the same topics? Thanks for your time!|

  57. I am not positive the place you are getting your information, but good topic. I needs to spend some time finding out more or understanding more. Thanks for great information I used to be looking for this info for my mission.

  58. What i don’t understood is if truth be told how you are not really a lot more neatly-appreciated than you may be right now. You are so intelligent. You realize thus significantly on the subject of this matter, produced me in my opinion consider it from so many varied angles. Its like women and men are not interested until it¡¦s something to do with Girl gaga! Your own stuffs great. At all times take care of it up!

  59. Hiya, I am really glad I have found this information. Nowadays bloggers publish just about gossips and net and this is really frustrating. A good web site with interesting content, that is what I need. Thanks for keeping this website, I’ll be visiting it. Do you do newsletters? Can not find it.

  60. I’m truly enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Superb work!|

  61. Good ¡V I should certainly pronounce, impressed with your web site. I had no trouble navigating through all tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your client to communicate. Nice task..

  62. I carry on listening to the newscast lecture about receiving boundless online grant applications so I have been looking around for the finest site to get one. Could you advise me please, where could i get some?

  63. It’s the best time to make some plans for the future and it’s time to be happy. I have read this post and if I could I wish to suggest you few interesting things or tips. Maybe you could write next articles referring to this article. I desire to read even more things about it!|

  64. Thank you for another informative site. The place else may just I get that type of info written in such a perfect manner? I’ve a challenge that I am simply now running on, and I have been on the look out for such information.|

  65. Just wish to say your article is as astounding. The clarity in your post is just excellent and i could assume you’re an expert on this subject. Fine with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work.|

  66. I would like to thank you for the efforts you’ve put in writing this site. I’m hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing skills has encouraged me to get my own website now. Actually the blogging is spreading its wings fast. Your write up is a good example of it.

  67. Just want to say your article is as amazing. The clarity in your post is simply spectacular and i could assume you’re an expert on this subject. Well with your permission allow me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please keep up the gratifying work.

  68. Thank you for some other informative site. The place else could I get that kind of info written in such a perfect method? I have a venture that I am simply now working on, and I’ve been on the look out for such info.

  69. Howdy, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you reduce it, any plugin or anything you can recommend? I get so much lately it’s driving me crazy so any assistance is very much appreciated.|

  70. Greetings from Colorado! I’m bored to tears at work so I decided to browse your website on my iphone during lunch break. I love the info you present here and can’t wait to take a look when I get home. I’m surprised at how quick your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, very good blog!|

  71. My coder is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using WordPress on a number of websites for about a year and am nervous about switching to another platform. I have heard fantastic things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any kind of help would be greatly appreciated!|

  72. Great blog here! Additionally your web site a lot up very fast! What host are you the use of? Can I get your associate link to your host? I desire my site loaded up as quickly as yours lol

  73. Aw, this was an incredibly nice post. Finding the time and actual effort to make a very good article… but what can I say… I procrastinate a lot and never seem to get nearly anything done.|

  74. Hello, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you protect against it, any plugin or anything you can recommend? I get so much lately it’s driving me mad so any help is very much appreciated.|

  75. I¡¦ve been exploring for a little bit for any high quality articles or blog posts in this kind of space . Exploring in Yahoo I eventually stumbled upon this site. Reading this information So i¡¦m happy to convey that I have a very good uncanny feeling I came upon just what I needed. I such a lot surely will make sure to do not omit this website and provides it a look regularly.

  76. Hey very nice site!! Man .. Beautiful .. Amazing .. I’ll bookmark your blog and take the feeds additionally¡KI am satisfied to seek out so many useful information right here in the post, we’d like work out more techniques on this regard, thanks for sharing. . . . . .

  77. Just wish to say your article is as amazing. The clarity in your post is simply spectacular and i can assume you are an expert on this subject. Well with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please carry on the rewarding work.

  78. obviously like your web site however you need to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I find it very bothersome to tell the truth on the other hand I will definitely come again again.|

  79. My spouse and I absolutely love your blog and find the majority of your post’s to be precisely what I’m looking for. can you offer guest writers to write content available for you? I wouldn’t mind producing a post or elaborating on some of the subjects you write concerning here. Again, awesome site!|

  80. Hello! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My web site looks weird when viewing from my iphone 4. I’m trying to find a theme or plugin that might be able to resolve this problem. If you have any suggestions, please share. Thank you!|

  81. you’re truly a excellent webmaster. The site loading
    speed is incredible. It seems that you are
    doing any distinctive trick. Also, The contents are masterwork.
    you have done a excellent process on this topic!

  82. I want to convey my respect for your kindness giving support to persons who must have assistance with your idea. Your special commitment to passing the message all over turned out to be particularly valuable and have always made many people like me to attain their aims. This insightful facts can mean so much a person like me and still more to my fellow workers. With thanks; from each one of us.

  83. You actually make it appear really easy along with your presentation but I find this topic to be really something which I think I might by no means understand. It kind of feels too complex and very huge for me. I’m having a look forward on your next submit, I¡¦ll attempt to get the hang of it!

  84. Nice read, I just passed this onto a friend who was doing some research on that. And he just bought me lunch since I found it for him smile Therefore let me rephrase that: Thanks for lunch!

  85. I’ve been absent for a while, but now I remember why I used to love this site. Thanks , I will try and check back more frequently. How frequently you update your website?

  86. you’re really a just right webmaster. The site loading pace is amazing. It sort of feels that you are doing any distinctive trick. Moreover, The contents are masterwork. you have done a fantastic process on this matter!

  87. Hello I am so happy I found your website, I really found you by accident, while I was searching on Bing for something else, Regardless I am here now and would just like to say kudos for a tremendous post and a all round entertaining blog (I also love the theme/design), I don’t have time to look over it all at the moment but I have saved it and also added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the great work.|

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2017/03/10/excel-sum-function
YouTube49
YouTube