I have a worksheet with almsot 40 items and everyday of the year, but i need
something to tell me quickly if there is something coming up this week. I can
do this for each day and column, but i am having trouble getting a formula i
can use to look at all the items, and count up all the items due that week.

This is what i have so far, the inital criteria "1" tells me there is
something due, the other is to see if it is the current week;

=COUNTIF(D16,1 & (IF(WEEKNUM(E16,2)=WEEKNUM(TODAY(),2),,1)))

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

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