Summing Data Less than zero

[howard]

I would like a formula to add up data less than zero in Col J based on criteria "GEN" (Col D)

See attached sample data

Your assistance in this regard is most appreciated

Excel Workbook
	C	D	E	F	G	H	I	J
2	JM751JMI	GEN	40437					3162
3	JM751JMI	GEN	40437					423.69
4	JM7517	GEN	40437					51.6
5	JM7527B	GEN	40438					0.02
6	JM7527B	GEN	40438					-0.04
7	JM7517C	GEN	40441					-422.93
8	JM7520B	GEN	40443					-183.48
9	JM7520C	GEN	40443					64.65
10	JM7520F	GEN	40444					39.28
11	JM1542E	GEN	40448					1753.09
12	JM1542F	GEN	40448					44.19
13	2815	PAY	40448					-1392
Sheet1

 

[njimack]

=sumproduct(--(b1:b12="gen"),--(h1:h12<0),(h1:h12))

 

[ramananhrm]

A		B		C		D
JM751JMI		GEN		16-09-2010		3162
JM751JMI		GEN		16-09-2010		423.69
JM7517		GEN		16-09-2010		51.6
JM7527B		GEN		17-09-2010		0.02
JM7527B		GEN		17-09-2010		-0.04
JM7517C		GEN		20-09-2010		-422.93
JM7520B		GEN		22-09-2010		-183.48
JM7520C		GEN		22-09-2010		64.65
JM7520F		GEN		23-09-2010		39.28
JM1542E		GEN		27-09-2010		1753.09
JM1542F		GEN		27-09-2010		44.19
2815		PAY		27-09-2010		-1392

<tbody>
</tbody>

Copy the below mentioned function at the bottom of Column D (D14)

=SUMIFS(D2:D13,D2:D13,"<"&0,B2:B13,"GEN")