This is the one that worked for me. Thank-you PEO for
spelling it out for me!
=SUBTOTAL(102,F1:F6)
Thanks to the others for trying and keeping this post
alive!
--Jim
-----Original Message-----
Just notice that 9 will sum while 2 will count numbers
and 3 will count
everything but blanks, finally if the rows are hidden
you have to prefix it
with 10 and only in excel 2003
=SUBTOTAL(103,E1:E15)
Regards,
Peo Sjoblom
"Frank Kabel" wrote:
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
.
.
.
|