Hello,
Here is my worksheet:

a b c d
1 contract amount
2 m-7-001 1,000
3 Not Yet 2,000
4. m-7-005 4,000
-------------
Subtotal 7,000,-
=======
My question is how can we make it, to ONLY subtotal if the column b is not
"not Yet"
I now there is a function of sum if, but we prefer sbutotal, because if we
filter column b by contract no. the subtotal can work the filtered ones while
for sumif I do not think it works

Thanks in advance for any idea provided.

Frank