I need to total column T IF column x="valid" AND column v="yes". I searched the forum and found:
=sumproduct(--(x3:x3000="valid"),--(v3:v3000="yes"),t3:t3000)
(I've put my columns in obviously.)
However the result looked familiar, so I tried my previous formula:
=sumif(x3:x3000,"valid",t3:t3000) and got the same result, even though I have rows with "valid" but without "yes". I need a total if BOTH conditions are true - what did I do wrong here?
And thanks for your support!
=sumproduct(--(x3:x3000="valid"),--(v3:v3000="yes"),t3:t3000)
(I've put my columns in obviously.)
However the result looked familiar, so I tried my previous formula:
=sumif(x3:x3000,"valid",t3:t3000) and got the same result, even though I have rows with "valid" but without "yes". I need a total if BOTH conditions are true - what did I do wrong here?
And thanks for your support!