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

Similar Threads

HOW TO ADD THE NUMBERS OF ROW WITH TWO VARIABLE? 2
Deleting rows containing zeros 2
countif using two variable 8
organizing rows and columns by text 1
sorting with xcel 2003 4
update a word as a prefix in a column for all rows. 2
Locating row with no duplicate matching amount 1
counting blank cells within two columns 2

Top