Using count formulas with '<='
 

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

The 3 members who didn't pay their fees on or before the due date
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/06


--
Drummy
------------------------------------------------------------------------
Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780
View this thread: http://www.excelforum.com/showthread...hreadid=548468

Using count formulas with '<='
 

Hi Drummy,

One way to do it yould be the Sumproduct:(Asuming your data starts in
A1)

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

Regards,
Bondi

Using count formulas with '<='
 

Bondi wrote:
Hi Drummy,

One way to do it yould be the Sumproduct:(Asuming 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