Count Nonblank cells and exclude Sub Totals

Can anyone tell me if it's possible to count a column of cells but exclude cells that contain a sub total. ie ignore anything that begins "=Sum("

Thanks.

Seve

First of all, do a Find & Replace (CTRL-H) on that column, and change SUM( to SUBTOTAL(109, (exactly as typed, including the final comma). Then you can use =SUBTOTAL(109,range) instead of =SUM(range) to get your correct subtotals.

Hope this helps.

Pete

Thanks for the reply Pete,
However, I am trying to count the cells in the column that are nonblank but exclude Subtotals from the count.

Hope this makes sense.

Seve.

If you mean count rather than sum, then use 102 instead of 109. For further details of what those numbers mean, check out Excel Help for the SUBTOTAL function. Blank cells will not be counted if you use COUNT (102), but COUNTA (103) will include formula blanks.

Hope this helps.

Pete