One way:

=SUMIF(M2:M86,"0",J2:J86)

or, since M is 1 or blank:

=SUMIF(M2:M86,1,J2:J86)



In article ,
heater wrote:

I need a formula for the following: If (m2:m860, sum J2:j86). I have a 1
or the cell is blank in column M and column J is numbers greater than 1.