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
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.
Please Login or Register to view this content.
Does anyone have any ideas ?
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
Just tried Mr Longlegs it works in the fact that it doesn't count the blank cells, but how can I adjust that to also not count 'O' zero's ?
I forgot to mention this in the original question :-(
Last edited by BlindAlley; 12-09-2017 at 11:11 AM.
You can add additional conditions, e.g.
=SUMPRODUCT((COUNTIF(OneCodes,$K56:$X56)=0)*($K56:$X56<>"")*($K56:$X56<>0))
Thanks, that works very well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks