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
|