Tracy,

If you mark p and a, could you just not use

=COUNTIF(A1:AE1,"p")/(COUNTIF(A1:AE1,"a")+COUNTIF(A1:AE1,"p"))

to get the present percentage.

--
HTH

Bob Phillips

"Tracy" wrote in message
...
Hi and thanks for all the help in the past from everyone!!!

I am setting up an attendance sheet with "p" for present "a" for absent
what
I want for each child is a percentage of the time in class for that month
being present there??? There are 31 days in a month (some anyways) so
there
is my problem, how do I get the percentage because we have saturday &
sunday
off plus some months are less than 31 days and I think you excel wizards
get
what I mean hopefully I explained it right????

Thanks Tracy