Hi guys,
I've been trying to work on MID Formula and I can't seem to figure out how am I going to work on this problem.
I have a series of 12 numbers, separated by comma, in one cell. Each number per order is represented by a category. My goal is to count the total of number categories tagged as 1 in each cell. To give a better perspective on how I wanted to do it, please refer to the attached file.
Hope you guys could help me out on this.
Thanks a lot!
Rekussu
Bookmarks