View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default How do I use nested countif statements?

use this if you are doing it in a cell

=SUMPRODUCT(--(a1:a50="big"),--(b1:b50="fat"),--(c1:c50="ugly"))

it will tell you how many records there are which meet the criteria for big
and fat and ugly.

otherwise you might look at pivot tables as a neat way of viewing your data.
Drag the date field into the columns, and the model number (count of model
number) into the data section.
very quick pivot table training is he
http://www.datapigtechnologies.com/ExcelMain.htm


--
Allllen


"Frank P Florida" wrote:

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