Re: Cell Count

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 23:20:03 +0100

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" <jlamson@kw.com> schrieb im Newsbeitrag
news:06bb01c4dcaa$11d74c50$a601280a@phx.gbl...
> 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
> >
> ><anonymous@discussions.microsoft.com> schrieb im
> Newsbeitrag
> >news:1fa301c4dca1$88f01fa0$a301280a@phx.gbl...
> >> 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 spread*** 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
> >> >>
> >> >>
> >> >.
> >> >
> >
> >.
> >
Quantcast