Exclude Specific Value And Count Cell With Sumproduct
DEFINITION:- In this example we will use SUMPRODUCT - ISNA and Match Function to only count the cells which do not match the value for the given reference range in match function with SUMPRODUCT.
Explanation:- We have 2 range here A53 :A57 & B53 : B57 now we will use Sumproduct with 2 negative sign (--) before the ISNA and Match Function. it actually convert the value in true and false and count the true value and add it. As a result it will give the number of cell which do not include the value same as in Item Code range & Item code 2 range.