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!