Referencing Row Numbers in Formulas

[Katie412]

I have a spreadsheet where I have two columns of numbers

Example:
Column C Column F
Start Row # End Row #
2 5
2 5
2 5
6 20
6 20
6 20

I would like to define a sumproduct using these rows as guides i
defining the range. I thought maybe I could use the indirect key t
reference these cells as the row number, but it's not working as
hoped.

=INDIRECT("SUMPRODUCT
($L$"&F2&":L"&C2&",$N$"&F2&":N"&C2&"")

It also doesn't like
=SUMPRODUCT("$L$"&F2&":L"&C2&",$N$"&F2&":N"&C2)

Anyone have any suggestions.

Kati

 

[J.E. McGimpsey]

one way:


=SUMPRODUCT(INDIRECT("$L$"&F2&":L"&C2),INDIRECT("$N$"&F2&":N"&C2))

 

[Katie412]

Thank you! It's all about the syntax.

It is appreciated