# Formula help

prhrmk
Guest
Posts: n/a

 1st Dec 2005

I have a production report by company that includes a column for (# of
creations) and a column that is for the date. The date goes by month
so that you have 1/1/2005 - 1/31/2005 and so on for each month for the
whole year of 2005.

The NEW report that I am working on will be merged with this one. I
need to create a weekly report for creation by date - example
Production Report for week of 1/1/2005 and this will include only five
days. I have a multitude of companies that will be on this report so
when viewed production will know exactly how many creations were made
for each company that week.

I suppose I am looking at a SUMIF type formula but not sure I know how
to create it . I hope this makes sense and I would
appreciate anyone that could guide me in the right direction.

Sincerely,
Paul

--
prhrmk
------------------------------------------------------------------------
prhrmk's Profile: http://www.excelforum.com/member.php...o&userid=23934

Bob Phillips
Guest
Posts: n/a

 1st Dec 2005
I think you want SUMPRODUCT

=SUMPRODUCT(--(B2:B200>=--"2005-01-01"),--(B2:B200<=--"2005-01-05"))

or something similar

--

HTH

RP
(remove nothere from the email address if mailing direct)

"prhrmk" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> I have a production report by company that includes a column for (# of
> creations) and a column that is for the date. The date goes by month
> so that you have 1/1/2005 - 1/31/2005 and so on for each month for the
> whole year of 2005.
>
> The NEW report that I am working on will be merged with this one. I
> need to create a weekly report for creation by date - example
> Production Report for week of 1/1/2005 and this will include only five
> days. I have a multitude of companies that will be on this report so
> when viewed production will know exactly how many creations were made
> for each company that week.
>
> I suppose I am looking at a SUMIF type formula but not sure I know how
> to create it . I hope this makes sense and I would
> appreciate anyone that could guide me in the right direction.
>
> Sincerely,
> Paul
>
>
> --
> prhrmk
> ------------------------------------------------------------------------
> prhrmk's Profile:

http://www.excelforum.com/member.php...o&userid=23934
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?bGVjYWJhbGxlcm8=?= Microsoft Excel Programming 1 2nd Nov 2005 12:46 PM Jonathan Windows XP General 10 13th Jan 2005 03:22 AM =?Utf-8?B?U2FuYXRhcml1bV83?= Windows XP General 2 25th Sep 2004 04:00 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM Muxer Microsoft Excel Programming 2 24th Jul 2003 01:02 AM

Features