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 |
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 |
All times are GMT +1. The time now is 02:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com