Hi,
I have a formula :
=SUMPRODUCT((('Totals'!$A$5:$A$11=J5:J11)*('Totals '!$B$5:$M$11)))
but it only returns the values for J5 J8 and J9, not 6, 7, 10 or 11, as
you would expect it to do. I have checked and the values it is looking
up are accurate (they work individually). Is this a problem with
sumproduct or am I just being a bit dim?
Thanks
--
sanders
------------------------------------------------------------------------
sanders's Profile:
http://www.excelforum.com/member.php...o&userid=36745
View this thread:
http://www.excelforum.com/showthread...hreadid=572127