You can't use whole columns like J:J, try using a range like J1;J5000
Regards,
Alan.
"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:9596092e4be14@uwe...
Hi -

Really stumped on this one. I have tried many different formula's using
SUMPRODUCT, And, IF in conjunction with Countif but still can't seem to
get
it to work.

I have a worksheet with dates listed down column B called "Schedule". I
need
to look in another worksheet, find two separate colunms true; if they are
both true then count. I continue to get the #NUM! error no matter which
way I
approach this. Any help would surely be appreciated. Example of the
"SUMPRODUCT" approach below [B163 is equal to a date of 06/09/2009 and K2
is
equal to a team number of L01 on the worksheet "Schedule"]


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

Thanks for any help

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