HOW DO I ADD ROWS WITH TWO TEXT VARIABLE
 

I'M USING A SPREAD SHEET. AND WANT TO ADD THE ROWS WITH TWO VARIABLE, LIKE
EXACT WORD. FOR INSTANCE, IF I WANT TO FIND OUT HOW MANY ROWS CONTAIN BOTH
WORDS IN A DIFFERENT COLUMN RANGING FROM C3 TO H33?

HOW DO I ADD ROWS WITH TWO TEXT VARIABLE
 

Hi BabyBlue,

If you just want to see how many times a certain word appears in each
column, try

=COUNTIF(C3:C33),"your word")+COUNTIF(H3:H33,"your word")

Hope that helps,

Phil