Excel 2007 : Formula change in Attendance Sheet

[firetraining]

I have an attendance spreadsheet, A1 through A38 are the employee names and the row designates their position. Colums C through AG, are the days of the week. "SL","D/SL","N/SL" are the designations of the sick leave types. Here is the formula that was built before I took over the spreadsheet.

=SUM(IF(((C18:AG18="SL")+(C18:AG18="D/SL")+(C18:AG18="N/SL")),1,0)).

Now this works fine until the crews decide to bid on different positions. Is there a way to make/change this formula so that when the employee moves from A1 to A23 that I can get the formula to update the move?

The formula is in D59 below the attendance matrix to give totals for the month and arrays down for the complete employee list. B59 is the Employees name alphabetically for Human Resources, I was thinking about using C59 to reference the row # for the employee and position up in the attendance matrix and have the formula reference that number, but of course I can't get it to work.

Any Thoughts???
Thank you in advance!!!

Tom

[DGagnon]

could you attach a sample workbook for this?

[arlu1201]

Hey Firetraining,

Welcome to the forum.

Your thread title is not as per forum rules. Please change it to something like "Formula change required" or "Formula change in attendance worksheet".

Click on Edit Post -> Go Advanced and edit your title.

[firetraining]

Never thought of that DGagnon.
Lol but here is the attachment. I modified the original to reduce the size of the file and highlighted the formula cells that I am having trouble with. I think it is pretty self explanatory.

Thanks in advance.

Tom

Attendance_Sample.xlsx