View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default 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