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 . . . .
|