What function to use - Counting numbers that meet a criteria??

  • Thread starter Thread starter greghann
  • Start date Start date
G

greghann

Hello,

I have three columns: Product, Quantity and Price.

Adjacent to that table of data I am doing some calculations.

I have used "COUNTIF" to determine how many times a product appears i
a column. So, for example, Product A appears 4 times in the colum
headed Product.

What I'd now like to do is: wherever Product A is found, look into th
column immediately to the right ("Quantity"), to find out how man
Product A's were sold, and then sum that total in my calculation
section?

Please help!

Gre
 
Use the SUMIF function. This allows you to look in one
colmn for a specified entry and sum a second column
corresponding to the specified entry.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use month in cell date to sum all relevant cells 2
count entries that equal one criteria if another column meets anot 7
I would appreciate some help with a formula 3
How to ignore a column of numbers in Grand Total for rows 1
divide column b by column a 4
Count columns that meet criterias 3
Counting on 2 criteria 2
count cells in a table that meet multiple criteria 1

Back
Top