Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif from different worksheets
I keep daily attendance and grades in a workbook. Each worksheet has a date
as its tab. Worksheets are formatted identically with Student names, attendance, etc in the same spot on each sheet. I wish to count the number of unexcused absences using the countif function on the last page of the workbook by counting the same cell for each kid on each worksheet. Nothing I've tried works. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif from different worksheets
What are the dates, are they a month, each day of a month, or what?
-- __________________________________ HTH Bob "BeefDr" wrote in message ... I keep daily attendance and grades in a workbook. Each worksheet has a date as its tab. Worksheets are formatted identically with Student names, attendance, etc in the same spot on each sheet. I wish to count the number of unexcused absences using the countif function on the last page of the workbook by counting the same cell for each kid on each worksheet. Nothing I've tried works. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif from different worksheets
Dates are given by mmddyy like 062708, 062708, etc.
"Bob Phillips" wrote: What are the dates, are they a month, each day of a month, or what? -- __________________________________ HTH Bob "BeefDr" wrote in message ... I keep daily attendance and grades in a workbook. Each worksheet has a date as its tab. Worksheets are formatted identically with Student names, attendance, etc in the same spot on each sheet. I wish to count the number of unexcused absences using the countif function on the last page of the workbook by counting the same cell for each kid on each worksheet. Nothing I've tried works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif in many worksheets | Excel Worksheet Functions | |||
Countif over several worksheets | Excel Worksheet Functions | |||
=COUNTIF across Worksheets | Excel Worksheet Functions | |||
countif across worksheets | Excel Worksheet Functions | |||
Countif multiple worksheets | Excel Worksheet Functions |