View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marley Marley is offline
external usenet poster
 
Posts: 4
Default Marking cell; totaling all # between marked cell & next marked cel

Hello,

I have created a workbook, including many worksheets for each month of the
year. The first row of each worksheet indicates the days of the month. The
first column lists all students in our classroom. The purpose of the
workbook is to keep track of attendance. The last column of each worksheet
totals the attendance hours/month for each student.

Problem: I need to somehow mark/highlight a cell (any particular date for
any particular student - dates will vary depending on the student) that would
show their last test date. Then I need to create another column at the end
of each sheet that would total the attendance hours for each student since
their last test. That is, when they take another test, I will need to mark
another cell/date (to indicate their new test date) and the total hours since
their last test will need to reset. The "total hours since their last test
date" will reset everytime they take another test...and begin summing from
the most recent test date each time.

Is their a formula that can accomplish this? If so, will it extend to the
next worksheet/month to count the hours between tests seamlessly?

I would greatly appreciate any help with this issue! Many thanks!!!
--
Jessie