Hi Mark

Try
=SUMPRODUCT((INDIRECT(A1):INDIRECT(A2)<1000)*
INDIRECT(B1):INDIRECT(B2))

--
Regards
Roger Govier

"Mark11" wrote in message
...
I am trying to make formulae that is used regularly be more user friendly.
Is there a way I can enter a range and use that input data in a formula.
e.g. in A1 type "D3" and A2 type "D50" B1 type "E3" B2 type "E50" then use
D3:D50 and E3:E50 in a formula, e.g.
=SUMPRODUCT(--(D3:D50<1000),--(E3:E50)).
I have tried many variations but none seem to work.
Any help would be appreciated.