Issues recognizing text and counting the cell depending on a condition

Hi!

It is my first time on this forum so I hope I don't oversee any of the rules. I am trying to do a quantitative analysis of tweets for a linguistics paper. I would like my formula to see if a condition is met and count the amount of cell where text (no specific one) is found. I would also like to count 'text' in more than one cell, and eventually be able to do a count per user.

I have tried several things I have deleted already, not knowing quite well what certain symbols actually do, and trying to adapt some of the examples of the forum. This was my last attempt:

=SUMPRODUCT(--('20 only'!$O$2:'20 only'!$O$1285="Chavismo"),--(ISTEXT('20 only'!$M$2:'20 only'!$M$1285),--(ISTEXT('20 only'!$N$2:'20 only'!$N$1285) )

Attached is a simplified example of what I am looking at.

Thank you in advance for your help!

Your replies were quicker than expected. Thank you!! I just did a manual count, FDibbins. I wish I were able to speak Excel better...

Oh, aha... of how many cells that have the word "Chavismo" have text on column called "User Mentions"

Apologies for the misunderstanding. What I want is to count, based on "User political side" options, how many cells have data per columns (E:E, F:F, G:G, H:H). Thus, I would like Excel to recognize all "Chavismo"s and count who many times Column E has text in those rows.

My formula should have been some more like this

=SUMPRODUCT(--($I$2:!$I$1285="Chavismo"),--(ISTEXT($I$2:$I$1285)),--(ISTEXT($E$2:$E$1285)).

I hope this makes more sense

You are a saint! It seems to be working. Thank you, thank you, thank you!!