Trying to build a log book in excel

Hello ,

First off there is a wealth of information in this forum and I am glad I found you all!

Now here is my issue I am using Excel 2011 on a mac and I am building a log for work. Please see the attached log. Page 1, Log has all of the information that we use. Page 2 has all of the Data. I want to be able to select the Specific Company from the drop down in this instance I selected Co.1 and for Program I selected Accident. Now when this information is selected I want it to populate automatically on Page 2 For all instances. I hope I was clear on what it is I am trying to accomplish and I hope it is something that Excel can do. Either way I appreciate any help or advice you can give.

Thank you,

Sgalbo

Steve.

Do I need to change the data in the formula for each line? Also will that work with the 19 different companies? Sorry to be a pain , I'm not really good with excel yet.

Ok that sort of works, when I add it sheet 2 it doesn't differentiate the company or program though.

I have attached an updated log, using the formula you gave earlier I copied and pasted in into the stats sheet, now when I select Co.1 and Accident etc.. it gives a final count of 8 as you can see from the attached spreadsheet. When I select Company 1-19 and then select the Program I want them to auto count it on the stats sheet. Thanks again I appreciate the help!Workbook2 with code.xlsx