•1 min read•from 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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#no-code spreadsheet solutions
#items
#total
#Apple
#Orange
#count
#2x
#comers
#12
#multiplied
#text
#multiply
#reddit
#Excel