Have you considered using a pivot table instead to create your reports.
Select the raw data and choose Data - Pivot Table - Follow the wizard...
Pivot tables are designed to aggregate (Sum, Average,...) grouped data such
that it can be presented in different ways from different view points. One
thing you will probabl want to do is use the Grou feature to aggregate the
data by month, quarter, year...
--
HTH...

Jim Thomlinson


"S Jackson" wrote:

I have a spreadsheet that I've used to track employee's different types of
sick leave. On one spread sheet I created a list of the types of sick
leave. Underneath I created a 5 column table to track each employee's daily
use of sick leave used or awarded. The first column the user selects an
employee from a drop-down list. The 2nd column is the date, 3rd column is a
drop-down to select the type of sick leave, the 4th column is for the user
to enter the amount of time awarded, and the 5th column is to enter the
amount of time used.

Out to the side I want to track each individual employee's monthly summary
for each type of leave.

I can create individual tables for each employee's different kind of leave
and it looks like this:

Monthly Summary of Sick Leave Bonus
Employee 1
Month Awarded Used Balance
Carryover
Sept 0.00 0.00 0.00
Oct 0.00 0.00 0.00
Nov 0.00 0.00 0.00
Dec 0.00 0.00 0.00
Jan 0.00 0.00 0.00
Feb 0.00 0.00 0.00
Mar 0.00 0.00 0.00
Apr 0.00 0.00 0.00
May 0.00 0.00 0.00
Jun 0.00 0.00 0.00
Jul 0.00 0.00 0.00
Aug 0.00 0.00 0.00


The formula in the Awarded column is: =SUMPRODUCT(--($A$10:$A$150="Amy
Castaneda"),--($C$10:$C$150="Sick Leave
Bonus"),--(MONTH($B$10:$B$150)=9),--$D$10:$D$150)

The formula in the Used column is: =SUMPRODUCT(--($A$10:$A$150="Amy
Castaneda"),--($C$10:$C$150="Sick Leave
Bonus"),--(MONTH($B$10:$B$150)=9),--$E$10:$E$150)

It works great, but the problem is the number of individual tables. There
are 10 employees and 4 different types of leave. This makes 40 monthly
summary tables - ack!

Is there a way to create one monthly summary table that changes to reflect
whatever employee a user has selected from a drop-down list somewhere?