View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sbrogins sbrogins is offline
external usenet poster
 
Posts: 2
Default 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 . . . .