I am trying to set up a leave time report for people to use. The format
is below:


Date Type or Leave Hours Taken
07/01/2005 A 8
07/15/2005 A 6
08/15/2005 S 5
etc etc etc


I need a formula to look at the date and find all leave taken for a
specific type of leave for the month and then total the hours taken for
that month. For instance, in the above example 14 hours for the month
of July. I only need the result of 14.
Please help. :)


--
tbird0566
------------------------------------------------------------------------
tbird0566's Profile: http://www.excelforum.com/member.php...o&userid=27375
View this thread: http://www.excelforum.com/showthread...hreadid=468942