Sumif formula using with subtotal

Elango6724

New Member
Joined
Apr 24, 2018
Messages
1
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
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

hotabae

Board Regular
Joined
Apr 18, 2018
Messages
167
Try only using the SUMIF function:

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

You don't need the Subtotal Function.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,751
Messages
5,524,621
Members
409,595
Latest member
therevford

This Week's Hot Topics

Top