stumped on summary?

  • Thread starter Thread starter Hammy
  • Start date Start date
H

Hammy

Hello newsgroup,
I have created an attendance sheet. Names in a column,
dates in a row across the top. Each cell has a value
(alpha-numeric, (the number "1", or one of 4 alphas)) or
is blank. I would like to summarize (number of counts for
each value) for each Name.

Have I given enough information? What obvious step am I
missing? Thank you for your help.
H.
 
Assume the names are in A2:A40 and the attendance values in B2:O40

=SUMPRODUCT((A2:A40="name1")*(B2:O40="value1"))
 
Back
Top