Thread: Cell Count
View Single Post
  #6   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use the formula as provided :-)
=SUBTOTAL(9,E1:E5)

and just open Excel's help and search for SUBTOTAL

--
Regards
Frank Kabel
Frankfurt, Germany

"Jim" schrieb im Newsbeitrag
...
I tried this:

=subcount(9,E1:E5)

and got this in return:

#NAME?

where can I find a reference of the different definitions
of that first parameter?

Thanks,

--Jim

-----Original Message-----
Hi
just try Peo's function. In this case using 9 as first

parameter is
does a COUNT

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im

Newsbeitrag
...
Hi Peo,

Thanks for the reply ... =subtotal adds the numbers

in
the column, I'm looking for a way to do just a cell
count. I have a spreadsheet with over a thousand rows

in
it. I've hidden the ones I don't need, and am trying to
figure out how to do a count pf how many records are
remaining.

I am using 2003.

Thanks,

--Jim

-----Original Message-----
Built in? Only in excel 2003

=SUBTOTAL(103,Range)

otherwise you would need a UDF or a macro


Regards,

Peo Sjoblom

"Jim" wrote:

Is is possible to do a cell count when you have

hidden
rows? How?

Thanks in Advance,

--Jim


.


.