What is in that range other than dates? I tried deleting a date to see if it
was being caused by blanks. That did not do anything. But when I inserted a
space in a cell I got the #value error. I am sure that other data could
cause that error. Like text (you can't perform the year function on text,
only on dates.)
--
Kevin Vaughn


"MAB" wrote:

This gives me a #VALUE! error message.

Is there anything else I can try?

Thank you,

MAB

"Kevin Vaughn" wrote:

Try:
=SUMPRODUCT(--(YEAR(D1:D2500) = 1999))
--
Kevin Vaughn


"MAB" wrote:

*sigh*

I regretted to provide information that the dates are formatted as
dd/mm/yyyy, so the formulas provided to me will not work.

Is there another way this can be done?

Sorry for the confusion.

Thank you.


"Bob Phillips" wrote:

Type

=COUNTIF(D1:D2500,1999)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"EdMac" wrote in
message ...

=COUNTIF(D1:D2500=1999) - use the year you want

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504479