Adding up Values of the Same vs. Unique Strings

Topic Labels: Formulas
587 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey there!

Let me give you some context: I am creating a packing note for a shoe manufacturer.

Here’s an example: Say we have four product batches, three of which are identical, one of which is different…

I’m using the ARRAYUNIQUE rollup formula to condense the three identical product batches into one, which is fine, but I also want to add up the total pairs by size of that unique batch, rather than, say, add up all the size 8s in the total shipment.

Here’s a screenshot… You can see i’ve managed to use ARRAYUNIQUE to only show the product reference and description once, but if I do the same with the size 8 column, for example, it’ll add them all up, won’t it i.e. 1 + 1 + 1 + 2 = 5, whereas I need it to be 3 + 2

I’m guessing I need a way of making the size 8 of one style unique to the size 8 of the other style??!

Thanks for your help in advance!


1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m calling on the big guns now - have any of you Airtable whizzes got an idea about this?

thanks in advance!