Ducttape19
New Member
- Joined
- Aug 28, 2002
- Messages
- 46
Hi all, here is the problem that I am having
I have a Raw Data page when column A is a team leaders name, column B is a date and column C,D,E,F... are text values.
On a "summary page" I have the team leaders name in cell B1 and the date I want in cell D1. From A4 to A10 are the criteria that I want from the text fields. Basically what I am looking for is a COUNTIF DATE,TEAM LEAD and TEXT value are a MATCH and give me the number of times it is a match.
If anyone can help me out I would apreciate it. Thanks
I have a Raw Data page when column A is a team leaders name, column B is a date and column C,D,E,F... are text values.
On a "summary page" I have the team leaders name in cell B1 and the date I want in cell D1. From A4 to A10 are the criteria that I want from the text fields. Basically what I am looking for is a COUNTIF DATE,TEAM LEAD and TEXT value are a MATCH and give me the number of times it is a match.
If anyone can help me out I would apreciate it. Thanks