referring to other cells with formulas

[Guest]

I have one cell with the following formula in Column Input!H2:H1000:

{=INDEX(AF8:AI8,MATCH(TRUE,AF8:AI8>=0,0))}
it produces the following number: 8175702492 in Cell Input!H2

on another worksheet I need to refer to the above number within the
following condition:

=SUMPRODUCT(--(Input!H2:H1000=J18),--(Input!$E$2:$E$1000=$M$19),--(Input!$A$2:$A$1000=A21),Input!$D$2:$D$1000)

however - when I do this - I get an #N/A -
when I take out the --(Input!H2:H1000=J18) condition - the formula works...

How can I include the --(Input!H2:H1000=J18) condition and have the three
conditions work simlutaneouly?

Alex

 

[JulieD]

see answer to your other post in this ng (approx 6hrs later than this one)