Sumproduct function

[j-mont]

Am having issues with this function, does anyone know of any issues with it?

Thanks

=SUMPRODUCT(--($B$4:$B$67<=2),--($B$4:$B$67>5.01),--($D$4:$D$67))

 

[Rick Rothstein]

Am having issues with this function, does anyone know of any issues with it?

Thanks

=SUMPRODUCT(--($B$4:$B$67<=2),--($B$4:$B$67>5.01),--($D$4:$D$67))

You are going to have to describe the "issues" you are having if you expect anyone to be able to help you.

 

[p45cal]

Am having issues with this function, does anyone know of any issues with it?

You'll certainly have issues (no, not issues, problems, issues are really things such as Egypt, Mali, Syria, Israel/Palestine etc.) with that formula as it hasn't a hope of returning much since the conditions seem to be mutually exclusive; what values can be both (less than or equal to 2) AND (greater than 5.01)?
Are you loking for values above 2 and less than 5?,
=SUMPRODUCT(($B$4:$B$67 < =2)+($B$4:$B$67 > 5.01),--($D$4:$D$67))
perhaps values either greater than 5.01 or less than 2??
=SUMPRODUCT(--($B$4:$B$67 > 2),--($B$4:$B$67 < =5.01),--($D$4:$D$67))

 

[Rick Rothstein]

You'll certainly have issues (no, not issues, problems, issues are really things such as Egypt, Mali, Syria, Israel/Palestine etc.) with that formula as it hasn't a hope of returning much since the conditions seem to be mutually exclusive; what values can be both (less than or equal to 2) AND (greater than 5.01)?
Are you loking for values above 2 and less than 5?,
=SUMPRODUCT(($B$4:$B$67 < =2)+($B$4:$B$67 > 5.01),--($D$4:$D$67))
perhaps values either greater than 5.01 or less than 2??
=SUMPRODUCT(--($B$4:$B$67 > 2),--($B$4:$B$67 < =5.01),--($D$4:$D$67))

Good point! I did not even bother to look at the formula because the OP said he had issues without telling us what they were, but yes, in looking at the formula, what you pointed out would definitely cause an "issue" to occur. I'm glad you choose to look at the formula in more detail than I did.