D
Diddy
Hi everyone,
I'm using the following sumproduct formula
=SUMPRODUCT(--(NoPass="W"),--(NoPass="N"),--(NoPass="D")) where NoPass is a
named dynamic range in Column C in Sheet 2. Formula is in Sheet 1
I would like to add a further criteria so that it will only count W, N and D
if corresponding cell in Range Matchup = "Matched" Column F Sheet 2.
As I'm typing this I'm wondering if it's possible and If I'm way off mark
here trying to do this with this formula ???
Basically what I would like to happen is if there is a W,D or N in say C2
and F2 =Matched then count it, if F2 does not equal matched then don't count
it.
Cheers
I'm using the following sumproduct formula
=SUMPRODUCT(--(NoPass="W"),--(NoPass="N"),--(NoPass="D")) where NoPass is a
named dynamic range in Column C in Sheet 2. Formula is in Sheet 1
I would like to add a further criteria so that it will only count W, N and D
if corresponding cell in Range Matchup = "Matched" Column F Sheet 2.
As I'm typing this I'm wondering if it's possible and If I'm way off mark
here trying to do this with this formula ???
Basically what I would like to happen is if there is a W,D or N in say C2
and F2 =Matched then count it, if F2 does not equal matched then don't count
it.
Cheers