You should be able to just offset your range without using the OFFSET
function.
Example:

=SUMPRODUCT(--(D3:D13="Sales"),(C1:C11)*(E3:E13))

HTH,
Paul

--

"Steve" wrote in message
...
Hi everyone. Is there a way to have a sumproduct embedded with an
offset function. Essentially, I will write the formula in Column C.
I need to scan column D, and for ever instance of the word "Sales"
multiply the cell directly to the right in column E by the cell in
column A, BUT 2 rows above! Possible? Thanks!!