a counting problem, please help!!

[p3project]

Dear All, Im hopeing someone can help me with a formula to do th
following -
I have a spreadsheet with dates in column A. In column J, I have mor
dates showing when a certain action takes place what I want to do i
have a running count of the number of entries in column A with a dat
of 2004 (not 2000, 2001, 2002, 2003) and the count the entries i
column J.

So if there is an entry in column J with a date of 2004 in column A
want it counted.

I hope this makes sense and would be grateful for any help.

Regards

Dav

 

[Frank Kabel]

Hi Dave
try
=SUMPRODUCT((YEAR(A1:A1000)=2004)*(J1:J1000<>""))

 

[Bob Phillips]

=SUMPRODUCT((YEAR(A1:A100)=2004)*(NOT(ISBLANK(J1:J100))))

--

HTH

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

 

[p3project]

you guys just blow me away, both formulas work a treat, many thanks t
you both.

Regards

Dave :cool