Forum Discussion

KF94607's avatar
KF94607
Copper Contributor
Jun 18, 2021
Solved

Count orders which contain a certain product

I have a table with data about orders where the products that are ordered each have a separate row, one row per product. Each order starts with an order number and then the product description. I'm l...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jun 18, 2021

    KF94607 

     

    Otherwise (if you don't run Excel 365), load your Orders table to the Data Model (Power Pivot) and setup a Pivot Table from there with Product in Rows, Order in Values and do a Distinct Count on Order field

     

    Sample attached

     

     

KF94607's avatar
KF94607
Copper Contributor
Jun 18, 2021
That's a great formula! Definitely learned something there. Thanks!

Resources