software

I have a workbook that has 31 pages in it for each day in a month. I
have multiple companies that I make either a delivery or a drop off for
each day. I want to be able to have one page that will compile by
company how many deliveries or pickups each company made for the month.
As I enter this day by day, I want it automatically updated on my master
sheet. I have an example file that I can send to anyone willing to take
a closer look. My email is
Thank you--
mrcastro3
------------------------------------------------------------------------
mrcastro3's Profile: www.excelforum.com/member.php...oamp;userid=29923
View this thread: www.excelforum.com/showthread...hreadid=496184I think it would be best to do counts in each worksheet for every company,
using countif, then aggregate in a summary sheet using sumproduct. examples

List the companies in the master sheet in A2:A20, then in the day sheets A2,
use
=COUNTIF($A$30:$A$200,Master!A2)
and copy down

On the master in B2, assuming the day sheets are named 1,2,...,31

=SUMPRODUCT(N(INDIRECT(quot;'quot;amp;ROW(INDIRECT(quot;1:31quot;))amp;quot; '!A2quot;)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;mrcastro3quot; gt; wrote
in message ...
gt;
gt; I have a workbook that has 31 pages in it for each day in a month. I
gt; have multiple companies that I make either a delivery or a drop off for
gt; each day. I want to be able to have one page that will compile by
gt; company how many deliveries or pickups each company made for the month.
gt; As I enter this day by day, I want it automatically updated on my master
gt; sheet. I have an example file that I can send to anyone willing to take
gt; a closer look. My email is
gt; Thank you
gt;
gt;
gt; --
gt; mrcastro3
gt; ------------------------------------------------------------------------
gt; mrcastro3's Profile:
www.excelforum.com/member.php...oamp;userid=29923
gt; View this thread: www.excelforum.com/showthread...hreadid=496184
gt;