Excel: Adding up multiple instances of numbers within one cell.

  • Greetings, I am trying to find a way to add up multiple occurrences of numbers within a column of cells. In some cells there may be more than one occurrence and I would like to count all of them within the cell. Also I would like to use strings like "2-5" and the code be able to read search for this also. At present I am using the Countif function, but I am pretty sure that that doesn't actually count the number of occurrences within the cell. I am attaching a sample. Column V are the cells of interest. My formulas are found in V152:V164. Thank you so much.