Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Text Across Multiple Columns
I am trying to count text and number in in column
example-I need a function that will count across two columns If the training hours =8 and Taining Type =CT3 or CT4 Results Would be =1 If the training hours =10 and Taining Type =CT3 or CT4 Results Would be =2 Column-1 Column-2 Training Hours Training Type 8 CT3 10 CT4 8 LR 8 QC 8 RSV 10 CT3 10 QC Thanks LaTanya R. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To count the data using multiple criteria in multiple columns | New Users to Excel | |||
Sum/Count Multiple columns | Excel Discussion (Misc queries) | |||
Count if Multiple columns | Excel Worksheet Functions | |||
how to count one value or another across multiple columns? | Excel Discussion (Misc queries) | |||
Count on multiple columns | Excel Worksheet Functions |