Question about greater than and less than in 1 statement

[shdawson]

Hi,


I am running a SUMPRODUCT formula. All was well (key-word "was"), but found a failing in the logic today.

Need to edit the formula.


I currently have Parameters!C$24 set to my run date. So, if the date in 'Project Task'!M$2:M$18000 is less than this date....it is late.

I then do some other columns to do a date range. Well, sad to say....found the logic is not solid.

=(SUMPRODUCT(--('Project Task'!C$2:C$18000=C32),--('Project Task'!O$2:O$18000<>1),--('Project Task'!I$2:I$18000="POR"),--('Project Task'!M$2:M$18000<=(Parameters!C$24))))-(SUMPRODUCT(--('Project Task'!C$2:C$18000=C32),--('Project Task'!O$2:O$18000<>1),--('Project Task'!I$2:I$18000="POR"),--('Project Task'!M$2:M$18000<=(Parameters!C$24-7))))

So, I have the date ranges figured out in my parameters sheet now. All I "think" I need to do is simplify the date thing in an arithmetic statement of some kind.

=(SUMPRODUCT(--('Project Task'!C$2:C$18000=C32),--('Project Task'!O$2:O$18000<>1),--('Project Task'!I$2:I$18000="POR"),--('Project Task'!M$2:M$18000<=(Parameters!C$24   AND GREATER THAN Parameters!C$23))))

This part always confused me in arithmetic. I need to hammer out the...."AND GREATER THAN Parameters!C$23" part.

Please advise.


Thanks.......

 

[Jonmo1]

Try

=SUMPRODUCT(--('Project Task'!C$2:C$18000=C32),--('Project Task'!O$2:O$18000<>1),--('Project Task'!I$2:I$18000="POR"),--('Project Task'!M$2:M$18000<=Parameters!C$24),--('Project Task'!M$2:M$18000>Parameters!C$23))

 

[shdawson]

Even an easier answer.

Wow, I love this SUMPRODUCT thing. It can most likely fry chicken and clean the pan afterwards as well.

Thank you, kind sir, for your assistance. Have a great day!


S