+ Reply to Thread
Results 1 to 5 of 5

using sum

  1. #1
    Registered User
    Join Date
    04-14-2016
    Location
    Las Vegas, Nevada
    MS-Off Ver
    most recent
    Posts
    3

    using sum

    I used to be able to add a column by highlighting the column from top to bottom, going down a couple of empty cells and then hitting the sum key. Now this won't work for me. I can see it is adding but it doesn't print the total. Any thoughts?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: using sum

    Hello,

    how do you see that "it is adding"? Which part of the screen?
    What is in the formula bar of the cell?

    Could you post a screenshot?

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    04-14-2016
    Location
    Las Vegas, Nevada
    MS-Off Ver
    most recent
    Posts
    3
    Thanks for replying. I see you helped me with my date problem too. I will write tomorrow. I left work. I was trying to get the job done so I ended up making my date field a character field. I was reading the so-called help and found out my numbers were "serial numbers" I guess it has to be complicated for people who have complex projects. I was trying also to use a simple formula. I wanted to multiply the numbers in column a by the numbers in column b and put the answer in column c. So in column c I I put =5a*5b. I got a message saying I made an error and asked if I wanted the program to fix it. I said yes. Then I left the cell and nothing happened. The formula just sat there. I read somewhere that I needed to hit f1 and enter. That didn't do anything. I'll check tomorrow. I may need more help than anyone can give. A class might help. Thanks


    QUOTE=teylyn;4364370]Hello,

    how do you see that "it is adding"? Which part of the screen?
    What is in the formula bar of the cell?

    Could you post a screenshot?

    cheers, teylyn[/QUOTE]

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: using sum

    So in column c I I put =5a*5b
    Try
    =A5*B5

    Cell addresses start with the column letter followed by the row number.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: using sum

    I ended up making my date field a character field. I was reading the so-called help and found out my numbers were "serial numbers"
    1. It is seldom a good idea to convert real; dates to text dates, they become pretty much unusable in formulas and need to be manipulated back to real dates
    2. All real dates in excel are serial numbers.

    What you need to understand about dates and times in excel is...

    a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Fri Apr 2016) is actually 42475

    Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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