I have a workbook which tracks maintenance issues in our building. Issues are entered on the second sheet called: Maintenace Tracking. The first sheet is a summary of issues by floor. I am having trouble with formulas in the first sheet which need to go and check two columns on the second sheet for certain criteria then give a running total of each issue.
The first sheet, titled Cover Sheet, is divided into columns by floor (two columns for each floor, one with different issues and one for how many of that issue).In the column for the second floor, in column D, first row (Camera issues),(cell D19) I need to put a formula which goes to the second sheet (Maintenance Tracking), column C and looks for all 2s (for second floor), then checks column E for the word "Camera" and tells me how many camera issues I have on the second floor.

Clear as mud? I can send you a copy of the worksheet.

Problem solved! Thanks to all who at least looked!

Would be nice if you can post the solution here ; someone someday will require the same solution

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)