K
Karl
Hi,
I wonder if someone could help. I’m 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
I wonder if someone could help. I’m 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