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