Morning Excel Helpers,

I have a requirement where I need to count a bunch of codes less another bunch of codes in a range.

I am trying to use this formula 

 =COUNTA($K56:$X56)-SUMPRODUCT(COUNTIF($K56:$X56,OneCodes))
K56:X56 is the range to count, and the OneCodes is the 'named range' of codes NOT to count, The Formula does count the codes but unfortunately it counts the blank cells too, I've tied adding a COUNTIF(K56:X56<>0,) into the mix but without success.

Does anyone have any ideas ?