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