Try using this formula to count cells that are both non-blank and not equal to codes in OneCodes
=SUMPRODUCT((COUNTIF(OneCodes,$K56:$X56)=0)*($K56:$X56<>""))
Try using this formula to count cells that are both non-blank and not equal to codes in OneCodes
=SUMPRODUCT((COUNTIF(OneCodes,$K56:$X56)=0)*($K56:$X56<>""))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks