Adding up numbers from one drop down cell to another

[Tlctristan]

Hi everyone I am new to this forum, I have been building a spreadsheet for tracking multiple employees, projects, Tasks and hours. I have validated columns and information and using macro in order to have multiple numbers in one cell in ascending order. In my hours cell I have lets say 3 different numbers like 1 and 2.5 and 3. My problem is I want all those numbers from that cell to add up automatically in another cell and I can't find anything online or anyone that can answer that question for me. Is there a formula or something I have to write in macro in order to do that or can this not be completed.
I have attached my excel file with the issue on the second sheet with a little description.
Thank you
Tristan

[TMS]

If that is a build number for Excel 365, maybe the formula:

Please Login or Register  to view this content.

[Tlctristan]

Im so stoked thank you again!!

[TMS]

I take it that's good

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Tlctristan]

Yes!! I asked so many people and you solved it in less than two minutes. I was told it can't be done. I worked on it for three days. This is awesome!!
Thank you very much.

[TMS]

I was told it can't be done.

It would have been a lot more difficult if you didn't have 365