Hi Dave

can't see how you get 1 for the example .. if you could explain what you
counted based on what else, ie how you got 1 then we might be able to help

Cheers
JulieD
"dave" wrote in message
...
Hi,

Firstly, I would like to thank everyone who has helped me in the past.

Unfortunatley another question which will hopefully put me on the right
path
for other functions.

I am trying to add up the number of date entries in a column, which are
are
on a date = or before the current date, and only if there is an entry on
the
same row in another specified column.

for example
A B
1 x 12/12/2005
2
3 r 10/10/2004
4 t

The total for this would be 1

Many Thanks