Using count formulas with '<='

[Drummy]

Ok, I have two columns
first one (H3:H17) representing the date in which fees were paid for
tennis club and the second (K3:K17) representing when the fees are du
(1/9/06)

The 3 members who didn't pay their fees on or before the due dat
aren't considered 'current' members,

I need to construct a formula which counts all the 'current' members.

I beleive it would need to be a count formula using a date and
counting if the date occurs prior to or on the due date.

plz help,

1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/14/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/17/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/10/06 1/9/0

 

[Bondi]

Hi Drummy,

One way to do it yould be the SumproductAsuming your data starts in
A1)

=SUMPRODUCT(--(A1:A17<=B1:B17))

Regards,
Bondi

 

[Bondi]

Hi Drummy,

One way to do it yould be the SumproductAsuming your data starts in
A1)

=SUMPRODUCT(--(A1:A17<=B1:B17))

Regards,
Bondi

And since you put in where your data is you could use this instead ;o)

=SUMPRODUCT(--(H1:H17<=K1:K17))

Regards,
Bondi