Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL COUNT of text
I have an excel file with a location code in col A (in text) and attendence
(marked as F, H, or A) in cols E-I (corresponding with days of the week). Each row is a person. I need to count each type of attendence for each type of code for the whole sheet. I've been screwing around with ifs, ands, sums, sumproducts. I must be making it harder than it really is . . . . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
conditional count | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |