wrt1mea

asked on

# I need to update a formula

Is there a way in include a list of values in a formula, to EXCLUDE from it counting. For example, I need to EXLUDE from the counts both BLANK spaces and "NOCODE" IN COLUMN B and am struggling with an effective way to do this.

=SUMPRODUCT((MFDATA!$D$2:$D$5000=$A25)*(MFDATA!$L$2:$L$5000="N")*(MFDATA!$C$2:$C$5000<>""))-SUMPRODUCT((MFDATA!$M$2:$M$5000=$A25)*(MFDATA!$L$2:$L$5000="N")*(MFDATA!$C$2:$C$5000<>""))

=SUMPRODUCT((MFDATA!$D$2:$

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER