Thread
:
Summing the number of incomplete jobs within a date range -sumprod
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Summing the number of incomplete jobs within a date range -sumprod
Testing shows it works both ways...
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I assume that the asterisk was intended to be a comma, Don? You wouldn't
need the first two double unary minuses if you were doing the
multiplication with an asterisk, of course.
--
David Biddulph
Don Guillett wrote:
=SUMPRODUCT(--(B2:B22<"")*--(B2:B22TODAY()+7),--(C2:C22<""))
Hello,
I need help figuring out a formula that counts the number of
incomplete jobs
for a specific worker that are within the next seven days. I would
only want
to count the "Date Completed" column if it was blank and within
seven days from today's date. I've tried using sumproduct, but I
can't seem to figure out how to get the date calculations to work
properly. My data looks similar to this
Worker Due Date Date Completed
Bob 1/18/2010 1/13/2010
Bob 1/21/2010
Bob 2/20/2010
Tom 1/20/2010
Tom 2/10/2010 1/10/2010
You help is much appreciated.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett