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

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
 
G

Guest

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.
 

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

count entries that equal one criteria if another column meets anot 9
How to return a number into letters? 4
Counting on 2 criteria 2
count cells in a table that meet multiple criteria 0
Search tab using indirect for number of times in a range 3
Countifs -Count no of times products have been sold on particular 4
How do I get the total number of items that meet 2 criteria in Exc 1
Counting Multiple Records by specific criteria 5

Top