Counting columns and specific Dates

[JulieD]

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

 

[Guest]

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

 

[Guest]

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