| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif against a range of text entries
Hi there,
I can't seem to find an answer here to the following problem: I have a Range of 15 Cells with Text, is there a way do do a "Countif" (or something similar) in a column in another File against All of these 15 Cells in just one formula? If I add the Countifs for all 15 cells, the formula is half a mile long and cannot be copied. Any help here is Very Welcome, Many Thanks in advance!! Rgds, Hilvert Scheper |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| how can I use Excel's COUNTIF to count column entries71 but <110 | New Users to Excel | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
