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 freelanceria on tarjonnut keskimäärin $21 tähän työhön
Hey, I can help you Excel. Please send file. I have 2 years of Excel. I'll start now I will 100% accurate right away. Waiting for your response Thanks!
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.