Sumif formula using with subtotal

[Elango6724]

Sir pls clarify i want to total only the negative values only with using subtotal and sumif formulas pls help

=Subtotal(9,Sumif(D1:D500,"<0")) this will formula getting error

 

[hotabae]

Try only using the SUMIF function:

=SUMIF(D1:D500,"<0")

You don't need the Subtotal Function.