Hi!

Hope someone can help me with this issue ... First, a description of my dataset:

Column A: Dates (30 days)
Row 1: Names of students (100 names in column B to CW)
Row 2: Each students age
Row 3: A notice of whether the student is internal or external.

Range (B4:CW33) : A number of classes the student has attended (0-?)

Ex.

Name John Brian Danny Eric
Age 21 22 21 23
Type Int Ext Ext Ext

Date
21. 0 0 0 0
22. 2 0 2 1
23. 0 1 0 0
24. 0 0 0 0
25. 0 2 1 1
26. 4 2 0 2
27. 0 0 0 2

Now the calculation:

In a cell I want to count the number of rows (dates in column A) where there are at least one student with a positive number of classes, and meting a criteria of age and internal/external.
Ex. for the criteria (Age = 21) and (Type = Ext) the result is 3 (dates 22, 25 and 26).

How is that possible within the SUMPRODUCT formula?

Thanks!