countif

F

fzl2007

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.
 
I

isabelle

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif 2
Countif with a Range of criteria 8
Countif gone wrong 2
How to count a coloum if two conditions are met 5
Modify a Formula 2
Modify Formula 2
Formulas and counting 8
Finding the weighted average of text that have been given values 1

Top