that far I got, but then got stuck trying to get the subtotals by the code in
column A. Luke's answer above does it, though, I just never had the syntax
quite right.

"Dave Peterson" wrote:

=countif(E:I,"F")
would count the number of F's in columns E:I



sbrogins wrote:

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

--

Dave Peterson