Hi,
Let's say I have a list with orders with every row has seller ID and a product serial nr
So it could be (the name and serial nr are different cells)
John A23
John A23
Marcus A25
John A25
So in another sheet I have
A23 A25
John 2 1
Marcus 0 1
Im in mobile so formatting might be bad. But what I want is for it to count how many units John and other personally have sold A23 and A25 each etc.
No this isn't actually about sale stars its just the easiest example describing the scenario since I can't do a spreadsheet on mobile.
Let's say I have a list with orders with every row has seller ID and a product serial nr
So it could be (the name and serial nr are different cells)
John A23
John A23
Marcus A25
John A25
So in another sheet I have
A23 A25
John 2 1
Marcus 0 1
Im in mobile so formatting might be bad. But what I want is for it to count how many units John and other personally have sold A23 and A25 each etc.
No this isn't actually about sale stars its just the easiest example describing the scenario since I can't do a spreadsheet on mobile.