Help!!!!! No clue what to do!

[John]

Hi. I am doing an attendance sheet for my school. I have
14 different rooms (with a class sheet for each "room
1", "room 2") and a class roster on each sheet. I also
have a row that has the number for the month that the
date is in ("9" for September, "10" for October, etc...)
If a student is absent, I put an "A" in the column.

I am wondering if there is a way to add up all of the A's
that a class has in a certain month (for example I want
to add all of the A's in September for Room 4. There
would be a "9" in rows D7:AC7 to indicate the dates took
place in September). SO I would want all of the A's in
D10:AC43 added up and sent to the "Teacher's List" sheet
next to "Room 4". Also how would I find a percentage for
the number of students that attended school out of 100%
if there are 32 kids in the class??? Sorry about the
questions but this is way to hard for me to figure out by
myself. Thanks so much for any help!

john

 

[Bob Phillips]

You already have responses to the other 2 versions of this question that you
posted. Why are you asking the same question 3 times?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[John]

My computer messed up and I didn't think the question posted. Sorry.