Nesting CountIF and TextBefore

Question

Morning all

From the attached doc, how would I ask Excel to count how many times the letter "E" appears in columns B, C etc. and the same for the letter "L". I thought I could use Textbefore and CountIF but I've tried a few times and can't get it to work. Can anybody help please? TIA, Louise

Answer 1

I can't get this one to work for some reason, it just displays 0. Don't know why...

Did this work for you?

TIA, Louise

Please, clarify and give more details. Could you show us what is happening with some pictures?

Thanks

Answer 2

Re, '... Can I not nest the TEXTBEFORE function with it in some way?"

I don’t see the need to do so. Your goal is to count the letters E and L.

COUNTIF function is enough to make it happen.

Re, "... Is there any way this can be done without having the letters E and L in separate cells?"

Yes,

Please try the following formulas

=COUNTIFS(B$2:B$6,"L")

=COUNTIFS(B$2:B$6,"E")

I hope this helps you

Regards

Jeovany

Answer 3

Hi and thank you for your response. Is there any way this can be done without having the letters E and L in separate cells? Can I not nest the TEXTBEFORE function with it in some way? Thanks again, Louise

Answer 4

If you want to count the exact letters "E or L" then try the formula

in cell B7**=COUNTIFS(B$2:B$6,$A7)** and copy across

Regards

Jeovany

Answer 5

Hi Louise

You may try the formula in cell B6 =COUNTIFS(B$2:B$6,"*"&$A7&"*") and copy across.

As shown in the picture below.

I hope this helps you,

Regards

Jeovany