Hi,

I wonder if someone could help. Im creating a worksheet for our department
to track, among other things, profitability.

I have a separate worksheet for reports. This pulls together data from
several other worksheets, each of which contains data on one specific
project.

One report has to track the monthly profitability of a particular category
of billable job. So what I need is a formula that says:

€œLook at the deadline column of the worksheet called Ad hoc. For all cells
with a date in January 2008 (for instance), calculate the sum of the
corresponding cells in the previous column (the one that tracks our fees)€�,

Can anyone tell me how to go about this?

Thanks

Karl