Count unique values in column and carry out related formula

Copper Contributor

Hi everyone,

 

I'm totally lost with this one and would be very grateful for any help!

 

I have a sheet with 3 columns: PO numbers, item quantity, item name.

 

This means, if a PO includes several items, there is a row for each item with the same PO, i.e. a PO can have several rows.

 

I now need to count the quantity of all items per PO (not how many different items, but how many items in total). Then I have to apply a different price per unit depending on how many items are in the order. 

 

E.g. up to 10 items per order > 0,35 per item

10 to 20 items per order > 0,30 per item

from 2 items > 0,20 per item.

 

Any idea how this can be accomplished?

 

Happy Tuesday :) 

Cheryl 

 

0 Replies