Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
count in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
want if cell containts text, then increase count by one | Excel Worksheet Functions | |||
how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions |