Counting multiple items in a cell

Hi there, 

Need help with a formula. Here’s what I’d like to do… imagine in one cell, comma separated values. Like..

5,+

The next cell has say something like 

4

I want one column of an excel sheet to add the numbers, and another column to count the +s. So – two values in one cell. So, the column would read 9 (adding the numbers), and 1 (indicating number of pluses). This would be super simple to just separate those two csv things into two cells, but that’s not how my data is.

Any thoughts?

 

By: Daniel Cook

Leave a Reply

Your email address will not be published. Required fields are marked *