HOW DO I ADD ROWS WITH TWO TEXT VARIABLE


8

8A8Y8LUE

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?
 
Ad

Advertisements

P

Phil

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top