+ Reply to Thread
Results 1 to 15 of 15

cells will not add up

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    cells will not add up

    i am highlighting a range of cells and dragging mouse but the cells will not add up im just getting a cell count not a total , but other cells in the column will add up

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,188

    Re: cells will not add up

    Check the number format of the cells - you may have some numbers stored as text.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    format seems to be numbers , although it will not let me put decimal places on either

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,188

    Re: cells will not add up

    Quote Originally Posted by bdf1965 View Post
    format seems to be numbers , although it will not let me put decimal places on either
    "Seems to be" ? Have you checked the actual cell number format (select cell, press Ctrl-1; or right click, format cells; or Format > Format Cells on Home ribbon) to see how it is formatted? It may look like a number but actually be formatted as text...

  5. #5
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,363

    Re: cells will not add up

    are you referring to the function in 2007 and later that when you highlight a column it shows the average, count and sum at the bottom of the spreadsheet?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  6. #6
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    yes have right clicked on cell , number option is highlighted blue

  7. #7
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,188

    Re: cells will not add up

    Ok - can you attach your workbook, please?

  8. #8
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    yes i normally click on the top cell and drag it down to get the total but it is not adding up , i have checked the format and it is number format

  9. #9
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    have attached sample
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    ps the workbook is massive , problem column is n235 : n293

  11. #11
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,188

    Re: cells will not add up

    In cells N283, N285 etc you are returning numbers as text - e.g. "1574" instead of 1574.

  12. #12
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    you will have to excuse me being an idiot but how can i tell this

  13. #13
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    yes i see what you mean i need to take the "" off in the formulas is that correct

  14. #14
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,188

    Re: cells will not add up

    Have a look at the formula in cell N235:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I have highlighted in red the quotation marks, which mean your numbers as being treated as text. Remove those quotation marks, and you'll get numbers, which you can then add up as you wish.

  15. #15
    Registered User
    Join Date
    10-23-2013
    Location
    essex
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: cells will not add up

    great thank you

+ 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