count number of values using countif

  • Thread starter Thread starter ronenpl
  • Start date Start date
R

ronenpl

Hi,

Maybe there is an excel funtion that can do this.

I need Excell to start at cell E4 and count the number of raws i
column E as long as E=a number
 
raws = rows?

=count(e4:e65536)

Take a look at excel's help for =count(). there's lots of siblings that may
come in handy someday.
 
=IF(MATCH(9.99999999999999E+307,E:E)>=CELL("Row",E4),SUMPRODUCT(--ISNUMBER(E
4:INDEX(E:E,MATCH(9.99999999999999E+307,E:E)))),"")

or, with a known range of interest like E4:E100...

=SUMPRODUCT(--ISNUMBER(E4:E100))
 
Forget those heavy-handed formulas... COUNT() will suffice. See Dave's post.

Aladin Akyurek said:
=IF(MATCH(9.99999999999999E+307,E:E)>=CELL("Row",E4),SUMPRODUCT(--ISNUMBER(E
4:INDEX(E:E,MATCH(9.99999999999999E+307,E:E)))),"")

or, with a known range of interest like E4:E100...

=SUMPRODUCT(--ISNUMBER(E4:E100))
Click to expand...
 
Back
Top