| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
| Entering Variable Text in Text Boxes...... | Excel Discussion (Misc queries) | |||
| sum and variable rows | Excel Worksheet Functions | |||
| How do I assign a text value to a variable number of rows? | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Linear Mode
