--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lee Hunter" wrote in message
...
How would I accomplish counting the number of occurrences in a table that
fall between upper and lower limit values on another sheet?

as in Countif(A1:Z1,"between sheet1!A1 and sheet1!b1")

Where a1:z1 are values to be compared against the upper and lower limit
and
then counted if they meet the criteria