Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Using SUM in formulas Excel 2007

  • 25-11-2012 04:07PM
    #1
    Gerry1995
    Registered Users, Registered Users 2 Posts: 224 ✭✭


    Just wondering why some people use the SUM function for most simple multiply and divide e.g if I want to multiply the content of say B10 by C10 I would use =B10*C10. Some people use =SUM(B10*C10) they give the same answer so why use SUM


Comments

  • #2
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,468 Mod ✭✭✭✭Capt'n Midnight


    =sum(a1:a20)


  • #3
    Gerry1995
    Registered Users, Registered Users 2 Posts: 224 ✭✭Gerry1995


    Capt'n, did you read my post, I have no idea what you mean by this response


  • #4
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,468 Mod ✭✭✭✭Capt'n Midnight


    try it ,

    it's like the old BASIC keyword LET

    as in LET A=1 it's optional A=1 is the same
    (but in many other languages you'd have to explicitly define A before you could say A=1)

    SUM is probably optional for one value
    to add a range you must use it.

    it's all in the help somewhere one supposes


  • #5
    Gerry1995
    Registered Users, Registered Users 2 Posts: 224 ✭✭Gerry1995


    I know well what the sum() function is for my question is what is the difference between =B10*C10 and =SUM(B10*C10) why would you use the sum version ?


  • #6
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,468 Mod ✭✭✭✭Capt'n Midnight


    Capt'n Midnight wrote: »
    try it ,
    ...

    it's all in the help somewhere one supposes
    :)


  • Advertisement
  • #7
    homer911
    Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭homer911


    Gerry1995 wrote: »
    I know well what the sum() function is for my question is what is the difference between =B10*C10 and =SUM(B10*C10) why would you use the sum version ?

    Because you have been badly taught, or dont have a clue what you are doing...


  • #8
    28064212
    Registered Users, Registered Users 2 Posts: 11,101 ✭✭✭✭28064212


    homer911 wrote: »
    Because you have been badly taught, or dont have a clue what you are doing...
    ^This. SUM(num) just returns num. There is no reason to do it. Might as well subtract zero, won't change anything

    Boardsie Enhancement Suite - a browser extension to make using Boards on desktop a better experience (includes full-width display, keyboard shortcuts, dark mode, and more). Now available through your browser's extension store.

    Firefox: https://addons.mozilla.org/addon/boardsie-enhancement-suite/

    Chrome/Edge/Opera: https://chromewebstore.google.com/detail/boardsie-enhancement-suit/bbgnmnfagihoohjkofdnofcfmkpdmmce



  • #9
    homer911
    Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭homer911


    Some programming languages cant cope with null or missing values in add statements, sum() will usually overcome this

    For example if A is null and B = 2

    A+B would result in null

    while

    Sum(A,B) would result in 2

    Perhaps whoever wrote the original sum statement was coming from this stable..


  • #10
    Gerry1995
    Registered Users, Registered Users 2 Posts: 224 ✭✭Gerry1995


    Ok thank you all for the contribution. I asked my question why would anyone use SUM in this way as my wife is attending a Business admin course and the tutor, who considers herself an Excel expert, always seems to write formulae in this way. I don't do this myself. Oh btw Homer, you just redeemed yourself following your less than helpful 1st reply, thank you for the clear explanation.


Advertisement