Hi there, I have searched this forum (and other Excel resources) for answers to my question but haven't been able to solve the problem yet, apologies if it transpires that I was being stupid and reading things wrong but I hope someone can help me anyway.
Firstly, I am using Excel 2007, SP3. And I don't know if this is a setting but my version appears to be using column numbers instead of letters. So the first cell is "R1C1" instead of "A1". But now I've got my head around how it works (especially for conditional formatting) I quite like it this way.
Anyway, my problem... I have a workbook that has three worksheets.
Worksheet 1 (called "Error Log") is a list of issues. Each row is a separate issue.
Worksheet 2 (called "Drop-downs") is just data for the drop-down menus in sheet 1.
Worksheet 3 (called "Stats") is going to be statistics about sheet 1, but this is where I'm having trouble.
In sheet 3 column 2 has dates formatted as MMMM so it just shows the month. For each month listed in sheet 3 I want to extract all of the following data from sheet 1:
1) The total number of rows in sheet 1 where month is the same as the current line in sheet 3 (dates in sheet 1 are in column 1).
2) The total number of rows in sheet 1 where month is the same as the current line in sheet 3 AND where company responsible is my company (company at fault is listed in column 3 of sheet 1).
3) The total number of rows in sheet 1 where month is the same as the current line in sheet 3 AND where company responsible is NOT my company.
4) The total number of rows in sheet 1 where month is the same as the current line in sheet 3 AND where company responsible is my company AND where team responsible equals my team (team at fault is listed in column 4 for sheet 1).
Please can someone help? if anything is not clear (I'm aware this might be confusing) then please ask.
Thank you.
Bookmarks