Forum Discussion

TheWeetek's avatar
TheWeetek
Copper Contributor
Jun 20, 2023
Solved

How to count number of products

Hey, help please.

How I can count, how many pcs were sold together?

 

I can do =countif(C185:C201;C199) to get the number of sold product without the D column,

which are number of pcs.

I need the excel to take the same name of the product from C185:C201 * number of sold products in column D and add it up. which means 1+4+5+1+1+3+5 etc..

 

Thanks.

 

 

Resources