Take another look at the formula that Per provided. The double unary
operator "--" coerces the logical "TRUE & FALSE" results of your arrarys
into numeric 1 & 0 which is required for the operation.


"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:959714f1c0c20@uwe...
Well - Still can't get it to work, double checked to make sure variable
matched formats ect... The new formula is =SUMPRODUCT('Team
Worksheet'!$J$1:
$J$5000=Schedule!$B163,'Team Worksheet'!$N$1:$N$5000=Schedule!K$2) but
brings
back a value of zero. I check and there is at least one that should be
counted.

Set it up on another worksheet for test, still got zeros????

Per Jessen wrote:
Hi

=SUMPRODUCT(--('Team Worksheet'!J:J=Schedule!B163),--('Team
Worksheet'!N:N=Schedule!K2))

The above formula will only work in XL2007. In previous versions, you can
not use a range like J:J, but something like J1:J1000.

Hopes this helps.

Per

Hi -

[quoted text clipped - 18 lines]

Thanks for any help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1