Sum Unique values from 31 pages
 

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: http://www.excelforum.com/member.php...o&userid=29923
View this thread: http://www.excelforum.com/showthread...hreadid=496184

Sum Unique values from 31 pages
 

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" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=29923
View this thread: http://www.excelforum.com/showthread...hreadid=496184