Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count and display unique values | Excel Worksheet Functions | |||
unique values in a cell base on another cell | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |