View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How do I use nested countif statements?

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