+ Reply to Thread
Results 1 to 3 of 3

What are these symbols

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    What are these symbols

    Hello fellow forum members.

    Excuse my ignorance but I am trying to enter a formula to do a simple running total in Excel 2002 and someone suggested using this formula =IF(B2="","",SUM($B$2:B2))
    My question is, what are the symbols "","", between B2= and SUM, and where are they located or where can they be accessed on the keyboard. Thanking you for your time and hopefully help Pedro147
    Last edited by Pedro147; 05-19-2012 at 12:42 AM.

  2. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: What are these symbols

    Hi Pedro

    I'll explain the whole formula

    =IF(B2="","",SUM($B$2:B2))

    If the entry in cell B2 is blank ("" - that's two quotes (the two key at the top numerics just above Q and W)) then result is blank ("") otherwise (if it is not blank) result is the sum of the range from B2 to B2 (which may appear to be nonsense in this case). However it is meant to be dragged or copied down to the cell beneath so that it will change the formula B2 to B3, B4 etc as it proceeds to be dragged down so that it will look at the entry in B2,B3 etc and always give the sum from $B$2 to the corresponding row. So if you are looking at say, C9 then the formula would look like =IF(B9="","",SUM($B$2:B9))

    Hope this makes sense.
    Last edited by Russell Dawson; 05-18-2012 at 11:37 PM. Reason: correction
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

  3. #3
    Registered User
    Join Date
    03-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: What are these symbols

    Hi Russell,

    Thank you so much for your prompt and clearly explained response. I am starting to understand a little more of the vagularities (I hope that is a proper word, after all I am from convict stock…) of computing generally and Excel in particular.
    I see that the British keyboard layout is different from ours in that the quote symbol is the top symbol on the key second from the right of the L letter or where your @ symbol is..(all very confusing as if Excel isn't confusing enough for me)
    Also I had to replace straight quotes with smart quotes in Autocorrect options, but with your help I got there.
    From your explanation I see that the $B$2 is an absolute reference and now that I know how to enter the correct quotes into the formula I am on my way. So thanks again Russell and all the best,

    Pedro147

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1