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

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

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