countif date function

[jayeliz]

hello everyone

I'm trying to do a countif function where I have a column of dates.
would like to do a count on how many persons were born on the year
1980 thru 1989. Here is a formula, but only counts that certain date
Any help would be appreciated. Thanks



=COUNTIF(Data!B2:B191,"=11/24/1983"

 

[Peo Sjoblom]

Couple of ways

=COUNTIF(Data!B2:B191,">="&DATE(1980,1,1))-COUNTIF(Data!B2:B191,">="&DATE(19
90,1,1))

or

=SUMPRODUCT(--(Data!B2:B191>=DATE(1980,1,1)),--(Data!B2:B191<DATE(1990,1,1))
)

note that I am using 1980 through 1989 not your example of 1983

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(YEAR(Data!B2:B191)>=1980),--(YEAR(Data!B2:B191)<=1989))

 

[jayeliz]

Once again....you have the answers. Thank so much for your help. Keep u
the good work!

 

[Soo Cheon Jheong]

Hi,


=SUMPRODUCT(--(LEFT(TEXT(B2:B191,"YYYY"),3)="198"))

or

=SUMPRODUCT(--(LEFT(TEXT(B2:B191,"YY"),1)="8"))


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

 

[b&s]

Hi, Soo Cheon Jheong

Please, leave OP question in your answer ...

--
regards/pozdrav!
Berislav

******************************************************************
ROT13 - email address (e-mail address removed)