1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Count and sum cells with items decided by comers and “x” used for multiples

Hi All,

How can I count items when divided with comers and multiplied with a text “x”? I’m only looking for the total number of items not how many of each type.

Apple Orange 0 2xApples Apple, Orange 2x Apple, Orange Apple, 2xOrange 

Total <- should be 12

submitted by /u/Previous_Badger4780
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article