Let me try to explain this better

[re3todd]

On Sheet1 Column L I'm looking for a value of "1"
I then want to take the value on Column I in the row or
rows that the "1" shows up,in Column L, and add the
values of the particular cell(s) and place sum in Sheet2
cell c3.

The value "1" was just an example, the actual value range
is 1 thru 16.

I hope the explains it better..

Thanks for any help you can give me...

 

[Paul Corrado]

This will return the sum of the values in column I for which the associated
value in column L is 1-16.


SUMPRODUCT(("col L range">=1)*("col L range"<=16)*("col I range")

HTH

PC