Forum Discussion
Product Count and Number Sold
I have a series of Excel worksheets in a single workbook that I create every month to track sales of products so I have columns for ITEM purchased and QUANTITY which is always one. There are up to 90...
I have another question if you could help please.
I have Item SKU, Date Sold, Quantity Sold
The SKU is up to 90 different, The quantity is always 1
How do I calculate how many of each SKU I have sold?
I have Item SKU, Date Sold, Quantity Sold
The SKU is up to 90 different, The quantity is always 1
How do I calculate how many of each SKU I have sold?
I would create a column of unique SKU
=UNIQUE( table1[Item SKU] )
then do a countifs
=COUNTIF( table1[Item SKU] , A1#)
where A1 is the location of that UNIQUE formula
=UNIQUE( table1[Item SKU] )
then do a countifs
=COUNTIF( table1[Item SKU] , A1#)
where A1 is the location of that UNIQUE formula