Adding values less than zero

[Rick Rothstein]

Give this formula a try...

=SUMPRODUCT((D2: D13="GEN")*(J2:J13<0)*J2:J13)

Change the ranges as needed, but make sure each range spans the same number of cells.

EDIT NOTE: Remove the space between the colon and D13... without it, the "colon D" gets replaced with a smiley emoticon.