Thursday, August 18, 2011

Excel 2007 Formula : count values in range

The objective of the formula is to count how many values of the column B (B2:B11) are between some specific values i.e 1,2 and 1,3:

The formula of the cell F2 is 

=CONTAR.SI($B$2:$B11;CONCATENAR(">=";D2)) - CONTAR.SI($B$2:$B$11;CONCATENAR(">=";E2))



No comments: