Functions Help!

[Guest]

Is there a function that will allow me to count a number in one column if
given a critera for a different column? For Example: If you had a spreadsheet
of products sold for September with columns labeled-Column A: Product -
Column B: Quanity - Column C: Date - Column D: Model - Column E: Amount, etc.
Could you count the Quanity in Column B only if a specific Model Name is
given in Column D
(EX: Soda Pop _ 4 _ 9-23-04 _ Pepsi _ $.75) I may have Soda Pop list 10
times in one spread sheet but I only want to count Pepsi quanties.

 

[Frank Kabel]

Hi
look at COUNTIF / SUMIF in Excel help

 

[Aladin Akyurek]

=SUMPRODUCT(--(ProductRange=G2),--(DateRange=H2),--(ModelRange=I2),QuantityRange)

where G2 houses a product condition, H2 a date condition, I2 a model
condition.

I assumed that you wanted to conditionally sum the Quantity range.

 

[BenjieLop]

=sumif(D1100,"Pepsi",B1:B100)

Is there a function that will allow me to count a number in one colum
if
given a critera for a different column? For Example: If you had
spreadsheet
of products sold for September with columns labeled-Column A: Produc
-
Column B: Quanity - Column C: Date - Column D: Model - Column E
Amount, etc.
Could you count the Quanity in Column B only if a specific Model Nam
is
given in Column D
(EX: Soda Pop _ 4 _ 9-23-04 _ Pepsi _ $.75) I may have Soda Pop lis
10
times in one spread sheet but I only want to count Pepsi quanties