Forum Discussion
Countif(s) problem
Hi all, I am currently trying to use the "countif" function on Excel and am running into some problems with cells that have multiple numbers. To preface this question, the cells at the top of th...
For example:
=SUM(--ISNUMBER(SEARCH(",1,", ","&B5LB8&",")))
=SUM(--ISNUMBER(SEARCH(",2,", ","&B5LB8&",")))
etc.
You're a hero!! This worked and you saved me from going down a VERY long rabbit hole! Thank you 😀