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