wondering if you can help me pls? In excel column I need to count the number of “D” and “d”. How do I differentiate in formula the capital letters from lowercase in the count? I entered =countif(e$6:e$17,”D”). And the same formula to count the lowercase but with a “d” instead. What would cost be to answer this question?
Good Day I can help to you for this case immediately I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Result will be excellent Best Regard
18 freelancers are bidding on average $21 for this job
SUMPRODUCT(LEN(E6:E17)-LEN(SUBSTITUTE(E6:E17,"d",""))) is the answer. If you like it, you can assign me the project and ask something else similar as well.