P
prhrmk
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
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 wouldappreciate anyone that could guide me in the right direction.
Sincerely,
Paul