If 1 is used to denote attending use =SUM(A1:A12) where the 1's are in the
range of cells A1 to A12
If P is used for 'present" then =COUNTIF(A1:A12,"P")
you need to tell us more.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"wiersma7" wrote in message
...
I have an Attendance sheet that I need to add the attendence totals from
each
month and move that total to another sheet (within same workbook)
--
jkw