a bit shorter

array formula (validate with ctrl+maj+enter)
=COUNTIF(INDIRECT("E2:E"&MATCH(9^9,E:E)),J2)

--
isabelle



Le 2012-04-06 11:56, isabelle a écrit :
hi,

if there are no empty cell in the range E2:Ex

=COUNTIF(OFFSET($E$2,,,COUNTA($E:$E)),J2)

otherwise an array formula (validate with ctrl+maj+enter)

=COUNTIF(INDIRECT("E2:E"&MAX(IF(NOT(ISBLANK(E2:E65 536)),ROW(E2:E65536)))),J2)