ExcelBanter - countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif (https://www.excelbanter.com/excel-worksheet-functions/445707-countif.html)

fzl2007

countif

I have this formula, =COUNTIF($E$2:$E$250,J2), which I want to modify
so that the range 250 will be dynamic like get the return of
=COUNTA(E:E). What is the best way to go about it?

Thanks.

isabelle

countif

hi,

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

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

--
isabelle

Le 2012-04-06 11:00, fzl2007 a écrit :
I have this formula, =COUNTIF($E$2:$E$250,J2), which I want to modify
so that the range 250 will be dynamic like get the return of
=COUNTA(E:E). What is the best way to go about it?

Thanks.

All times are GMT +1. The time now is 12:00 PM.