Sum Unique values from 31 pages

[mrcastro3]

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 [email protected]
Thank you

[Bob Phillips]

I 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("'"&ROW(INDIRECT("1:31"))&"'!A2")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mrcastro3" <[email protected]> wrote
in message news:[email protected]...
>
> 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 [email protected]
> Thank you
>
>
> --
> mrcastro3
> ------------------------------------------------------------------------
> mrcastro3's Profile:
http://www.excelforum.com/member.php...o&userid=29923
> View this thread: http://www.excelforum.com/showthread...hreadid=496184
>