I'm using Excel 2002 to create a spreadsheet to track false fire alarms for a system of group homes I work with. I'd like to create a table (not a pivot table) that counts the number of fire alarms per house per month. In the attached workbook, I'd like the formula in B4:B11 of the "Summary" tab to count each occurrence of a fire alarm for each residence during each month. For example, B4 in the summary tab should look at 'Data' Column A and C and count the number of times "Boxcar Lane" occurs in Column C, during the month of August from the dates in Column A. I've tried playing around with a few formulas and I can't get it to work. Any suggestions? Keep in mind, there are a few homes listed in the Summary tab that have NO occurrences at all in the data tab, and therefore should return a value of zero. Thanks!
Bookmarks