Greetings,

I still need to use an old version of XL, namely XL2000Pro on both w7 and
WXP systems, in consequence, there may be features I do not have.

I have a column to count the letter "y", at present, the formula used for
example is:

=COUNTIF(D3:D45,"y")

Is there a way I can replace the 45 by something which says I want a count
of all "y" in column d from 3 until reaching this line?  for instance,
something like:

=COUNTIF(D3:D%n,"y")

or

=COUNTIF(D3:D+,"y")

remember, it must be useable by an old version of XL.

Thanks.


    VICUG-L is the Visually Impaired Computer User Group List.
Archived on the World Wide Web at
    http://listserv.icors.org/archives/vicug-l.html
    Signoff: [log in to unmask]
    Subscribe: [log in to unmask]