Hi
try
=SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(B1:B100<=TODAY()))

"dave" wrote:

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