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
View this thread: http://www.excelforum.com/showthread...hreadid=489779

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
> View this thread: http://www.excelforum.com/showthread...hreadid=489779
>