View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank P Florida Frank P Florida is offline
external usenet poster
 
Posts: 3
Default How do I use nested countif statements?

Thank you very much for your help this worked perfectly.

"Roger Govier" wrote:

Hi Frank

Try Sumproduct
=SUMPRODUCT(($A$1:$A$100=DATE(2006,11,13))*($B$1:$ B$100="Model"))
Change the date value and "Model" to suit.

You may be looking for lust the Year, as opposed to an individual date,
in which case I would do the following.

Place your "Model" in cells e.g. in cell D2:D10
and place your Dates in cells E1:H1 e.g 1/1/2000, 1/1/2001, 1/1/2002
then copy the following to E2 and copy down and across as appropriate
=SUMPRODUCT(($A$1:$A$100=E$1))*($B$1:$B$100=$D2))

Better still, create a Pivot Table.
For help on creating Pivot Tables take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/f...es/pivot1.html


--
Regards

Roger Govier


"Frank P Florida" <Frank P wrote in
message ...
I want to be able to count the values in a list that meet two different
criteria. There is one column of dates and then another column of
model
numbers. I want to create a row of the number of model number per
date. Any
help is appreciated