View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
41db14 41db14 is offline
external usenet poster
 
Posts: 10
Default How do I use nested countif statements? Same ?

Allllen, Your suggestion worked great!! Thank you very much
What are "--" ?? I have never used them.
Could not tell the difference between your first suggested fomula and the
second?


"Allllen" wrote:

sorry I should have written
=sumproduct(--(B$2:B$474=365),--(W$2:W$474="Sam Jones"))

--
Allllen


"Allllen" wrote:

=sumproduct(--(B$2:B$474-365),--(W$2:W$474="Sam Jones"))
--
Allllen


"41db14" wrote:

Frank I also have the same question...
This is the CountIF function I'm using but can't seem to get it to do what I
want.
In column B I'm counting the number of days between dates that are equal to
or greater than 365 days...that part works fine...but I also want to have the
countif only look at a specific persons name in column "W". Excel accepts
the format but does not return a correct answer...??

=COUNTIF(B$2:B$474,"=365""Sam Jones")

"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