Formula - count certain dates in a column

[p3project]

Hi, can anyone help please. I have a spreadsheet containing dates in on
column ie. 12-Feb-04 etc. I need to set up a running total that count
only the 2004 entries (ignoring the 00, 01, 02, 03 etc etc

Can anyone help me with the formula plz???

Regards

Davi

 

[Bob Phillips]

=SUMPRODUCT(--(YEAR(A1:A100)=2004))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[p3project]

Thanks bob, your a champ.

Cheers

Dave :cool