On Thu, Sep 15, 2005 at 06:34:50PM +0100, Oliver Burnett-Hall wrote:
=sum(if(and($g$2:$g$30000>=h2,$g$2:$g$30000<h3),1,0))
[snip]
Have you tested that formula in Excel? I'd be very surprised if it worked.
I've not tested it. But it does seem syntactically valid, right? If not, where did I mess up the syntax? -- Stephen R. Laniel steve laniels org +(617) 308-5571 http://laniels.org/ PGP key: http://laniels.org/slaniel.key
Attachment:
signature.asc
Description: Digital signature