Adding values less than zero

[Howardc]

I would like to add values in col J than are less than zero where the ref in Col D is "GEN"

Your assistance in this regard is most appreciated

[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.

[Admin]

Hi

You could also try SUMIFS

=SUMIFS(J2:J13,D2: D13,"GEN",J2:J13,"<0")

[Howardc]

Thanks for the help, much appreciated