How do I count cells with texts but wouldn't include in the count those cells containing spaces, can't remove those spaces as I need them in my conditional formatting.
Attached file with the supposed count I need if I ain't being clear. Thanks
How do I count cells with texts but wouldn't include in the count those cells containing spaces, can't remove those spaces as I need them in my conditional formatting.
Attached file with the supposed count I need if I ain't being clear. Thanks
Enter formula in C22 and drag formula across
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thanks, how about if the word "project" isn't a constant in the other cells? i mean if the other cells has also texts that I want counted but doesn't include the word project
Last edited by mia12; 10-10-2019 at 09:31 AM.
Then, switch to use SUMPRODUCT+SEARCH:
=IFERROR(1/(1/SUMPRODUCT(0+ISNUMBER(SEARCH("project",Schedule[2])))),"")
Regards
Bosco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks