Count if 2 things

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
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try:


=SUMPRODUCT((Sheet1!$A$2:$A$10=$B$1)*(Sheet1!$B$2:$B$10=$D$1)*(Sheet1!$C$2:$F$10=$A4))

where A2:F10 houses the table on your Raw data sheet and Sheet1 is the name of your Raw Data sheet.

Adjust ranges and Sheet name to suit.

Copy down




Edit...corrected references on current sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,091
Messages
5,545,906
Members
410,711
Latest member
Josh324
Top