Hi
3 options:
1. Refer your formula to column A =SUBTOTAL(103,A1:A4)
2. That's only possible if cells in column A are either empty or contain text, then you can count twice and substract results of numbers form the total:
=SUBTOTAL(103,B1:B4)-SUBTOTAL(102,B1:B4)
3. Modify your formulas in column B to =IF(A1="",#N/A,A1) (copying to the end of your list)
Now you can use =AGGREGATE(3,3,B1:B4) to count.
|