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