1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How do I get a sum from one cell with multiple numbers into another cel

    From Chauncey Gearhart@21:1/5 to All on Wed Feb 24 09:42:29 2021
    Hello Fellow Spreadsheet Lovers,

    I have an issue. I am trying to get the total from a cell (E76) that contains all these numbers $65, $1619.82, $69.95, $6.37 and add them together in another cell (E17). What would be the appropriate formula to do this?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Thibaud Taudin Chabot@21:1/5 to All on Thu Feb 25 11:15:55 2021
    Op 24-2-2021 om 18:42 schreef Chauncey Gearhart:
    Hello Fellow Spreadsheet Lovers,

    I have an issue. I am trying to get the total from a cell (E76) that contains all these numbers $65, $1619.82, $69.95, $6.37 and add them together in another cell (E17). What would be the appropriate formula to do this?

    don't put all those numbers in one and the same cell. Put them each in a separate cell.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)