Aggregating Quantities (Col. B) of Each Unique Item (in Col. A)


#1

Hi there,

I’m trying to use Airtable to summarize my Woocommerce daily data. Each row represents an order. In Column A I have the product name and in Col B I have the quantities purchased. Values in Column A often repeat themselves as different customers order the same products.

Now what I would like to do is to create a summary of the total quantities purchased of every unique product in Column A. Problem is – products keep getting added and I would like a formula that does not require me hard-coding CountIFs.

Does anyone have a solution to this? Any help / direction you can point me to would be most appreciated!

Best regards,
Daniel


#2

If the product field is a Link to Another Record, you can have a separate table for “products”, and in your [Products] table you could have a Count field that counts the number of Orders linked to the product.