Have a look at this site
http://www.xldynamic.com/source/xld....T.html#classic for a
detailed explanation of the sumproduct syntax
HTH
Bassman62;333015 Wrote:
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 -

d text clipped - 18 lines Wrote:


Thanks for any help

--
Message posted via OfficeKB.com
'Excel - using Excel worksheet functions'
(http://www.officekb.com/Uwe/Forums.a...tions/200905/1)



--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92988