| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count a value if next to another value...
I'm entering data in a chart, and want to pull stats off that chart. Most
entries are text, but two columns contain types and codes. Lets say the set of types is A,B,C, etc.., and the set of codes is 1,2,3, etc... I want to count to get percentages of rows containing type A that are code 1 over all rows containing type A; rows containing type A that are code 2 over all rows containing type A, etc. for type B and C; also rows containing code 1 over all rows, etc. for code 2, code 3; Little help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Threaded Mode
