| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count text then add results
I wish to add a row of cells that contain x or xx or xxx etc this I can
do with:- =SUM(COUNTIF(C47:G47,"x")+COUNTIF(C47:G47,"xx")+CO UNTIF(C47:G47,"xxx")+COUNTIF(C47:G47,"xxxx")+COUNT IF(C47:G47,"xxxxx")) The above gives me a count of the number of cells containing my criteria:- However I wish to count the occurrences, contents of the cells: of how many x in the range? e.g. c d e e f x xx x xxx = 7 I am new to this nay help would be gratefully received! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count only visible results of formula | Excel Discussion (Misc queries) | |||
| need to compare dates and count results | Excel Worksheet Functions | |||
| How can I count the results ??? | Excel Worksheet Functions | |||
| count occurence and present results | Excel Worksheet Functions | |||
| how do I set the status bar to count results from filter? | Setting up and Configuration of Excel | |||
Threaded Mode
