Need a formula:If Statement

[heater]

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

[JE McGimpsey]

One way:

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

or, since M is 1 or blank:

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



In article <ED23A3D7-8A4E-4299-9485-735062B26DCE@microsoft.com>,
heater <heater@discussions.microsoft.com> wrote:

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

[Paul Black]

Hi Heater,

You could put this Formula in Cell "N1" for Example :-
=IF(SUM(M2:M86>0),SUM(J2:J86),0)

All the Best.
Paul