You can't use nested countifs. You can, however, use SUMPRODUCT for that
purpose. See here for some info:
http://www.meadinkent.co.uk/xlsumproduct.htm
Dave
--
Brevity is the soul of wit.
"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