john3j

06-15-2009, 09:33 AM

Hello all. I am trying to write a formula like a previous one:

=SUMPRODUCT(--('Test Data'!Z2:Z787="Basic"),--('Test Data'!G2:G787="09"))

Here is the problem, now I need to count if there are four different names in column Z. Even if I could have it exclude one or two specific ones. Lets say for instance that I needed it to count the following conditions:

1. Column z = "Basic" and column g = "09"

2. Column z = "Hard" and column g = "09"

3. Column z = "Silly" and column g = "09"

4. Column z = "Impossible" and column g = "09"

How can I include all of these and exclude all others?:dunno

=SUMPRODUCT(--('Test Data'!Z2:Z787="Basic"),--('Test Data'!G2:G787="09"))

Here is the problem, now I need to count if there are four different names in column Z. Even if I could have it exclude one or two specific ones. Lets say for instance that I needed it to count the following conditions:

1. Column z = "Basic" and column g = "09"

2. Column z = "Hard" and column g = "09"

3. Column z = "Silly" and column g = "09"

4. Column z = "Impossible" and column g = "09"

How can I include all of these and exclude all others?:dunno