Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by yoondix3 on April 6th, 2009

yoondix3

Question

Help answer this question below.

Excel If column A = first name of customers column B=quantity of product sold how can i find the sum of the quantity sold by two customers(ex. sum of quantity of john and bill)

  • Like
  • Report
Share:
Other

Answers. 2 helpful answers below.

  • by mubashiraziz on April 8th, 2009

    mubashiraziz

    The simple formula is

    =SUMPRODUCT((A2:A20="john")+(A2:A20="bill"),(B2:B20))

    suppose your data is in row 2 to 20

    No comments. Post one | Permalink

  • by Cyanotic Wasp on April 6th, 2009

    Cyanotic Wasp

    Let's say that names are in A1:A1000 and corresponding quantity values are in B1:B1000.

    In any cell outside of that range:

    =sumproduct((( A1:A1000) = "John") * ( B1:B1000)) + sumproduct((( A1:A1000) = "Bill") * ( B1:B1000))

    is a way to do it with a formula.

    This is also an excellent time to learn about Pivot Tables and what they can do, too. This is a perfect table to work on to demo that.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading Excel If column A = first name of customers column B=quantity of product sold how can i find the sum of the quantity sold by two customers(ex. sum of quantity of john and bill)

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Excel if column
How to find quantities sold in excel
Sum qty by product formla excel
Excel if column a column b
Excel if column first cell

Answerbag

a Demand Media company