Forum Discussion

Carlos1290's avatar
Carlos1290
Copper Contributor
Apr 18, 2020
Solved

COUNTIFS with <>= and cell reference

Hello, my issue is that I am trying to count the number of observations between a range of values, and the COUNTIFS formula fits perfectly. If I write the formula as >=, <= and write the number it wo...
excel
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 18, 2020

    Carlos1290 Try writing the criteria similar to this (suppose A1 holds the number you want to use in the COUNTIFS:

    "<=" & A1

     

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 19, 2020

Carlos1290 

A nice feature of COUNTIFS etc, is that it is possible to test many intervals simultaneously as an array

= COUNTIFS(

observed.times, ">=" & interval.start, 

observed.times, "<"  &  interval.end )

If the results form a continuous set of 'bins', FREQUENCY will achieve a similar result

= FREQUENCY( observed.times, time.slots )

Resources