Identify a Product and count How many units need to be made

Copper Contributor


I have been given a task at work.

I have a 3 column table of sales orders products and quantities to produce.


I need a identify the products from there unique value which may appear multiple times in the column.


A product can be identified from its 3 and forth character eg

xx23xxx indicates it’s a 23 inch box.

there is xx93xx which is a 93 inch box etc 


I need identity all the times 23 inches box appears and count the quantity that need to be produced.


What formula do I need.. match and count? 

Help is require. I will give a screen dump tomorrow if need be. Thanks 



2 Replies


How about

= LET(
      size,     CONCATENATE("*",MID(products,3,2),"*"),
      distinct, UNIQUE(size),
      SUMIFS(quantities, products, distinct)