Not quite becuase i need to look over all the dates, not just one of them, i
think i figured it out though:
(This is also looking off other sheets, not specified in original question)

=SUMPRODUCT(ISNUMBER(SEARCH(WEEKNUM(TODAY(),2),'Ta rget Closed
Date'!$C$3:$C$368))*('Target Closed Date'!$G$3:$AS$368=1))

and if you need it for the next week just add +1 after "TODAY(),2)" like this:

=SUMPRODUCT(ISNUMBER(SEARCH(WEEKNUM(TODAY(),2)+1,' Target Closed
Date'!$C$3:$C$368))*('Target Closed Date'!$G$3:$AS$368=1))

Thank you for your help though, bringing up SUMPRODUCT made everything click
: )

"VBA Noob" wrote:


Would this help

=SUMPRODUCT(--(WEEKNUM(D16,2)=WEEKNUM(TODAY(),2)*(--($E$16:$E$100=1)*(--($E$16:$E$100)))))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562800