S asked in Computers & InternetSoftware · 9 years ago

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".

Update:

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.

2 Answers

Relevance
  • 9 years ago
    Favorite Answer

    Assuming the columns are column A for 'Sales' and column B for units sold, use this formula in the cell of your choice:

    =SUMIF(A:A,"Sales",B:B)

  • pete l
    Lv 6
    9 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

Still have questions? Get your answers by asking now.