I'm completely stuck. I have a spreadsheet that has a worksheet for
each month of the year plus an extra one called TOTALS.
In each month there is one row per employee (there are about 20-30
employees) and the columns represent the days of the month. Its a
spreadsheet to calculate holiday totals.
The idea is: the holdays get entered with a '1' and in the TOTALS list
there's a drop down of the names of the employees. The select their
name and the total appear for each month. I've tried nested IF's but
I'M limited to 7. I don'T have much programming knowlege and I can'T
figure out how to solve this problem.
I attach a zip file containing my example
I'm grateful for any help.
+-------------------------------------------------------------------+
|Filename: holiday.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3749 |
+-------------------------------------------------------------------+
--
karambos
------------------------------------------------------------------------
karambos's Profile:
http://www.excelforum.com/member.php...o&userid=16262
View this thread:
http://www.excelforum.com/showthread...hreadid=399447