How do I have Excel tell me how many units were sold when it reads "Sales"?
What is the formula in Excel when I want it to tell me how many "Sales" we have? I want excel to let me know how many in total machines we've sold every time it reads the word "Sales".
I do have one column that reads "SALES" or it will read "INVENTORY", and next to it, there's a column that shows the quantity of how many units we're sold.
- garbo7441Lv 79 years agoFavorite Answer
Assuming the columns are column A for 'Sales' and column B for units sold, use this formula in the cell of your choice:
- pete lLv 69 years ago
Do you mean you have a column with the word 'Sales' in it for every sale and you want to count the number of times 'Sales' appears if not, you need to give more information