Posts tagged Excel SUMPRODUCT

How to count or calculate “unique” data in Excel (count duplicate data once)

Have you ever faced an Excel situation wherein you need to count or calculate rows and columns of data uniquely? Or in other way of saying — to count duplicate data only once? This can done using “Pivot Table” approach, but Excel also has several formulas that you can exploit to come up with the same results. Suppose you are operating an online store. Your website’s back-end e-commerce system reports sales per item and per day, like the table below: Suppose further that you want to know how many unique… Read More