Forum Discussion
TheWeetek
Jun 20, 2023Copper Contributor
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.
- Detlef_LewinSilver Contributor
- TheWeetekCopper Contributorhey, I was able to do it through SUMIF() finally.
thanks