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

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.

-----Original Message-----
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 in
a column. So, for example, Product A appears 4 times in
the column
headed Product.

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

Please help!

Greg


---
Message posted from http://www.ExcelForum.com/

.