CountIFS and Sumif based on duplicate value in other columns

[jennybell]

Hi,

I have a large dataset made of orders (duplicate order id in column A for orders containing multiple items). I need to calculate total price of order based on unit price/item.
I have tried to sumif(take(filter but it doesn't work.

Same for a countifs based on multiple criteria located in different columns BUT with the need to remove the duplicates in column A. I have tried the sumproduct, filter,
unique, distinct, they all return as 1 instead of giving me proper value.

I am completely stuck... please help me. This is what my table looks like for the first question with the first order id being the SAME but with different items.

order id	unit price	Order accepted time
xxxxxxx	8.99	0.4
xxxxxxx	0.99	0.4
yyyyyyy	1.63	0.7

 

[Vogateer]

What would determine whether a row is a duplicate in column A? Would the first two rows of info be duplicates, or not duplicates because their unit prices are different? What result would you want for order id xxxxxxx?

 

[jennybell]

in column A the order id would be a duplicate if they are exactly the same, for example the first two rows are the same order but the person ordered two different items priced at 8.99 and 0.99. For this specific order I would want a new column to return total price of order such as 8.99+0.99

 

[jennybell]

What would determine whether a row is a duplicate in column A? Would the first two rows of info be duplicates, or not duplicates because their unit prices are different? What result would you want for order id xxxxxxx?

in column A the order id would be a duplicate if they are exactly the same, for example the first two rows are the same order but the person ordered two different items priced at 8.99 and 0.99. For this specific order I would want a new column to return total price of order such as 8.99+0.99