SUMPRODUCT?

[Guest]

I have spent my weekend on this and still can’t figure it out.

I have a workbook with two worksheets, one is Data and one is Report

One the Data worksheet I have about 20 columns from a data dump. Here are
the columns I want to report on:

MAIL
10/2/2006 7:00
10/3/2006 7:00
10/3/2006 7:30
10/3/2006 8:00
10/4/2006 8:30
10/4/2006 8:00
10/4/2006 8:30
10/4/2006 8:40
10/4/2006 8:50
10/4/2006 8:50

TEAMNAME
DB2
DB3
D19
D18
D18
D19
DB2
DB3
D18

GIVENTOUW
Yes
Yes
Yes
No
No
No
Yes
No

PRIMEELIGIBLE
Yes
No
No
Yes
No
No
No
No
No

This is what I want to capture on my Report Page:

Team
(Listed Individually)

Completes
(by date –grouping all times) & (GIVENTOUW=Yes)

Incompletes
(by date –grouping all times) & (GIVENTOUW=No)

Prime Eligible
(any date)& (PRIMEELIGIBLE = Yes) & GIVENTOUW=NO)


I have tried SUMPRODUCT but I must be doing many things wrong. Can you help
me? Thanks

 

[Don Guillett]

the idea behind sumproduct is to sum c2 that meet the criteria
=sumproduct((a2:a200="joe")*(b2:b200=1)*c2:c200)

 

[Guest]

So if not SUMPRODUCT, what formula would i use?