User Profile
TheWeetek
Copper Contributor
Joined May 29, 2023
User Widgets
Recent Discussions
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.VLOOKUP - not available
Hey. I have some codes, which I selled in some orders. I have them in cells with some additional text. I need to use =vlookup (in czech =svyhledat) to write to the codes, that they were sold in order 20230387, but its not working. that one cell, which is "NENI K DISPOZICI" its "Not available" in english. normally the command works, when I write it as you might see, that when I write it just like this, it works (without the text), so I guess, error is in the "*"&A16&"*" ; but I don't know, how to write it. any help? thanks
