Oct 24 2017
03:15 AM
- last edited on
Jul 25 2018
10:16 AM
by
TechCommunityAP
Oct 24 2017
03:15 AM
- last edited on
Jul 25 2018
10:16 AM
by
TechCommunityAP
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