Subtotal < 0
 

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

Subtotal < 0
 

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

Subtotal < 0
 

=SUMPRODUCT(SUBTOTAL(109,OFFSET(J10,ROW($J$11:$J$3 000)-ROW($J$10),,1)),--($J$11:$C$3000<0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tufail" wrote in message
...
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

Subtotal < 0
 

thank you very much, that's what i was looking !

"SeanC UK" wrote:

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

Subtotal < 0
 

thank you very much, that's what i was looking !

"Bob Phillips" wrote:

=SUMPRODUCT(SUBTOTAL(109,OFFSET(J10,ROW($J$11:$J$3 000)-ROW($J$10),,1)),--($J$11:$C$3000<0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tufail" wrote in message
...
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