Subtotal for Negative values

[Ravindra R]

Is there any way to Subtotal Negative values in a column.

 

[vrunda]

See the attached file , if it helps- using helper column

 

[Hui]

If you just want to Sum the values less than 0 use: =SUMIF(D6:D20,"<0")
If you just want to Sum the values greater than 0 use: =SUMIF(D6:D20,">0")

Subtotaling is generally done when a second, sorted column changes values

 

[John Jairo V]

Hi to everyone!

Please see the file and comment!. Blessings!

 

[Ravindra R]

Hi to everyone!

Please see the file and comment!. Blessings!

Hi John
Thanks for the details, this will help me.
But as such there is no specific formula to get Sutotals for negative values, as in your file you have used SUMPRODUT, OFFSET in getting the result.

thanks
Ravindra R

 

[Hui]

Ravindra

Did you read my post above ?

 

[Ravindra R]

Ravindra

Did you read my post above ?

hi Hui,

Yes I read your post.
But my requirement was when i apply filter and move to next level of filitering i need to get the Subtotals to be applied for the data i have filtered.
If i use Sumif the values doesn't change, so i was looking in this forum if there is any way for looking Sum of Subtotal Negative values.

Sorry if i was not able to put down my requirement correctly.

Thanks
Ravindra

 

[Hui]

Have a read of:
Http://www.chandoo.org/wp/about-hui...-no-037-how-to-count-and-sum-filtered-tables/