stumped on summary?

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

Peo Sjoblom

Assume the names are in A2:A40 and the attendance values in B2:O40

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top