Hi,

And thankyou in advance. I've used this forum many times but now I have the need to register and post my own question. Here is the situation.
In one spreadsheet I use multiple sheets to track sales and installation dates. The sheets are each two week periods that track paydays basically. In one of the columns, after a sale, I input the date it will be installed (closed) as a date such as [10/11] for October 11th. Other columns to the right are labelled as the days of the two weeks, e.g. columns labeled [10/5] [10/6] [10/7]. In those columns, to the right of where I input the date the sale closes, I input a number between 1-3 to indicate the lines of business.

-----------10/5------10/6----10/7---10/8---10/9----10/10

10/11------3
10/11-----------------2
10/15---------------------------3
11/10------------------------------------1
11/03---------------------------------------------2
10/20 --------------------------------------------1
10/29---------------------------------------------------------3


This is an example of what I'm talking about in case its not clear.

What I would like to do is be able to search down the column on the left for all dates on all sheets with the value of (calendar date, e.g. 10/20) and then search to the right of those columns for the sum of those numbers and have that number displayed on a cell in another spreadsheet(the calendar).

Basically I want to see all my lines of business that will close for each calendar day but I'm not quite sure on how to search amongst those sheets for that information. I'm open to all suggestions and appreciate any input you all have to offer. I'm afraid my explanation might not be clear because I'm on a 18 hour shift so I apologize for that

OMG<<----this guy