Hi

You seem to be missing the outer set of brackets from your formula
SUMPRODUCT((Sheet1!$C$1:$C$1000=A3)*(Sheet1!$L$1:$ L$1000=B2))

--
Regards

Roger Govier


"penri0_0" wrote
in message ...

Thanks both,

I am making my 'look up' ranges in both columns i need to sum from
absolute - (and not selecting columns!) - but i still get 0.

Perhaps my formula is incorrect? In cell B3 i have:
SUMPRODUCT(Sheet1!$C$1:$C$1000=A3)*(Sheet1!$L$1:$L $1000=B2)

A3 contains one of my agents ID, B2 one of the the product types.
Sheet 1 column C contains the selling agents IDs also, Sheet 1 column
L
contains the products (of which thewre is more than one type).
Is it possible to sum using 2 lookups, as this would seem infinately
more reliable!

Roger - i can't use the filter for this piece of work, but thanks!


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile:
http://www.excelforum.com/member.php...o&userid=28947
View this thread:
http://www.excelforum.com/showthread...hreadid=548970