title: Linking correctly multiple criteria formula to another worksheet
body: <p>I will be brief as possible.  Here is a calculation that I have put together in my sheet titled "Input".  </p>
  
  <p>=SUMPRODUCT(--($E$11:$E$61>=$AE$5),--($E$11:$E$61&lt;=$AF$5),--($H11:$H61=$D$330))</p>
  
  <p>I've created a sheet titled "Results" that I would like to place the result of the above calculation.   Here is my latest attempt...</p>
  
  <p>=SUMPRODUCT(--(Input!$E$11:$E$61>=$AE$5),--(Input!$E$11:$E$61&lt;=$AF$5),--(Input!$H11:$H61=$D$330))</p>
  
  <p>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.</p>