The count would have to be in another cell, so why not count the
number of items in an adjacent column when you are setting up the
Subtotals parameters?

Hope this helps.

Pete

Function_num (includes hidden values) Function_num (ignores hidden values)
Function
1 101 AVERAGE
2 102 COUNT
3 103 COUNTA
4 104 MAX
5 105 MIN
6 106 PRODUCT
7 107 STDEV
8 108 STDEVP
9 109 SUM
10 110 VAR
11 111 VARP

use the function "Subtotal", look in help how to use it (start with 9 for
sum, start with 2 for count or 3 for counta)

rdwj