Sum formula for Only Negative Values

[aarti_rto]

Hello,

i have below data

Part Number	SFG Part Number	Requirement
A	AA	10​
B	BB	5​
C	AA	-20​
D	CC	-10​
E	AA	-30​
F	DD	-10​
G	BB	-10​
H	DD	-20​

and i need Sum of only negative values..like i need below answer for above data table.

SFG Part Number	Total Requirement
AA	-50​
BB	-10​
CC	-10​
DD	-30​

 

[Fluff]

You can use the SUMIFS function for that. SUMIFS Function

 

[aarti_rto]

You can use the SUMIFS function for that. SUMIFS Function

how to apply value condition in SUMIFS?

 

[etaf]

as mentioned SUMIFS() for numbers less than zero

=SUMIFS($C$2:$C$9,$B$2:$B$9,A13,$C$2:$C$9,"<"&0)

Book2
	A	B	C
1	Part Number	SFG Part Number	Requirement
2	A	AA	10
3	B	BB	5
4	C	AA	-20
5	D	CC	-10
6	E	AA	-30
7	F	DD	-10
8	G	BB	-10
9	H	DD	-20
10
11
12	SFG Part Number	Total Requirement
13	AA	-50	-50
14	BB	-10	-10
15	CC	-10	-10
16	DD	-30	-30
Sheet1

Cell Formulas
Range	Formula
C13:C16	C13	=SUMIFS($C$2:$C$9,$B$2:$B$9,A13,$C$2:$C$9,"<"&0)