referring to other cells with formulas

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

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"ALex" <[email protected]> wrote in message
news:[email protected]...
>
> 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