Thread: formula to add certain data and then move to another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default formula to add certain data and then move to another sheet
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


Reply With QuoteReply With Quote