Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Greenwich, Connecticut, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum of values (Excel 2002)

    I am trying get a total of certain selected cells in the columns of my worksheet some of which contain alpha characters. Please see attached xls file. It is not practical for me to re-sort the rows or group the data in a different way. Anyone know how to get around the error message. I'm new to Excel so there may be a very elementary solution or it may be impossible - I just don't know enough. Thank you for your help.
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum of values (Excel 2002)

    The formula below works in B11, you should be able to adapt it for the others.

    <pre>=SUM(B2,B4,B6,B8)
    </pre>

    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    Greenwich, Connecticut, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum of values (Excel 2002)

    That works - Thank you, I do really apprepicate your help.

Posting Permissions

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