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