View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Allowing for a range using COUNTIF

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