Help Counting Outstanding Assignments

[hooty1222]

I have a workbook to chart assignments given to 30 or so subcontractors. Each contractor has a tab within the book. The table in each tab the following column headers: Lease #, Date Ordered, Date Due, Date Received.

I'd like an index page that shows a column with each of the contractors name and column that shows the number of assignments outstanding for that particular contractor, with 'outstanding' meaning that there has been a Date Due entered, but no Date Received entered. Everything I've tried has resulted in "0" being returned.

Any help would be appreciated!

 

[Roderick_E]

Hi, on the new summary sheet we need a column that has the exact tab name of each contractor. For our example, let's assume you put the contractor tab names column in column A starting at A2 with the header in A1.
Further, let's assume on each of the contractor tabs the due date column is column A and the date received column is B.
Back on the Summary sheet, in the adjacent column to the contractor tab names, we have this code:

=COUNTA(INDIRECT("'" & A2 & "'!A:A"))-COUNTA(INDIRECT("'" & A2 & "'!b:b"))

Dragdown formula. Modify to your needs