Stephen -
Use SUMPRODUCT such as
=SUMPRODUCT((A1:A10030)*(A1:A100<60))
This will be produce two arrays of True and False results, also
represented as 1 and 0. If TRUE to the first and FALSE to the second
the product pair would be 1 * 0 or 0. If it meets both criteria the
pair would be 1 * 1 or 1. Summing the product pairs will be the same
as a count.
- John
www.JohnMichl.com