Hi Tufail,

It depends on what you want the cell to display. If you want it to display
"<0" when less than zero and otherwise the total then try:

=IF(SUBTOTAL(109,$J$11:$J$3000)<0,"<0",SUBTOTAL(10 9,$J$11:$J$3000))

But if you only want to display less than zero or greater/equal to zero then:

IF(SUBTOTAL(109,$J$11:$J$3000)<0,"<0","=0")

I hope this helps,

Sean.

--
(please remember to click yes if replies you receive are helpful to you)


"Tufail" wrote:

hello,
how can i get less than 0 value in subtotal, now i am trying with follow:
=SUBTOTAL(109,$J$11:$J$3000,"<0")
but it's not working.
thanks