Sum Unique values from 31 pages

M

mrcastro3

I have a workbook that has 31 pages in it for each day in a month.
have multiple companies that I make either a delivery or a drop off fo
each day. I want to be able to have one page that will compile b
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 maste
sheet. I have an example file that I can send to anyone willing to tak
a closer look. My email is [email protected]
Thank yo
 
B

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)
 
Top