Thank you NPM, Bob already told me the correct formula. I know how to make
subtotal, but what I want is withe the subtotal there is a kind of sumif. coz
I want the "Not Yet" excluded from the subtotal. When we want to filter the
specific contract name, the subtotal will show the filtered ones whileas
sumif does not have this capacity.

Thanks

Frank

"NPM" wrote:

Sorry for a typo, in this case the formula will be =subtotal(9,D2:D4)

"NPM" wrote:

Hi Frank

If I understood this right, Col B is your list of contract names, one of the
values is "Not Yet",
A B C D
1 Contract Amount
2 M-30 7000
3 N-35 6000
4 Not Yet 7909

You can use the function, =SUBTOTAL(9,D5:D7) at the top of D if you wish,
apply filter & use the custom setting of "where row B does not equal "not
Yet". your subtotal displays the sum of the other 2 rows , in this case
13000. Does this help? Please let me know

"Frank Situmorang" wrote:

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