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