I will be brief as possible. Here is a calculation that I have put together in my sheet titled "Input".
=SUMPRODUCT(--($E$11:$E$61>=$AE$5),--($E$11:$E$61<=$AF$5),--($H11:$H61=$D$330))
I've created a sheet titled "Results" that I would like to place the result of the above calculation. Here is my latest attempt...
=SUMPRODUCT(--(Input!$E$11:$E$61>=$AE$5),--(Input!$E$11:$E$61<=$AF$5),--(Input!$H11:$H61=$D$330))
The correct answer should be 4. However, on my Results sheet... I am coming up with 42. Not exactly sure what I am doing incorrectly.
After reading the comments provided by @RonRosenfeld, I can see that the correct way to write this calculation is as follows...
=SUMPRODUCT(--('Sheet1'!$E$11:$E$61>='Sheet1'!$AE$5),--('Sheet1'!$E$11:$E$61<='Sheet1'!$AF$5),--('Sheet'!$H11:$H61='Sheet'!$D$330))
Making sure that EACH element of the calculation that is being referenced is led by the appropriate page name and !.