View Single Post
  #5   Report Post  
Old February 26th 09, 02:28 AM posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Marking cell; totaling all # between marked cell & next marked cel

Let's see if this is what you want:

T = test

...........A...........B..........C
1....Header..Header..Header
2.......10..............................
3.......12..............................
4.......14..........T..........36...
5.......10.............................
6........4...........T..........14...
7........2..............................
8........2..............................
9........2...........T...........6...

If that's what you want enter this formula in C2 and copy down as needed:

=IF(B2="T",SUM(A$2:A2)-SUM(C$1:C1),"")

--
Biff
Microsoft Excel MVP


"Marley" wrote in message
news
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