F fzl2007 Apr 6, 2012 #1 How do I modify =COUNTIF($E$2:$E$250,J2) so that 250 is dynamic which will be the row count with data?
How do I modify =COUNTIF($E$2:$E$250,J2) so that 250 is dynamic which will be the row count with data?
I isabelle Apr 6, 2012 #2 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:E65536)),ROW(E2:E65536)))),J2)
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:E65536)),ROW(E2:E65536)))),J2)
I isabelle Apr 6, 2012 #3 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 :
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 :
