Tag: use of isna and match function

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.