Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to add certain data and then move to another sheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|