f2e4
01-19-2011, 02:53 AM
See attached sheet.
I am trying to do a SUM function to simply work out annual totals per project.
However, not all projects ended in December, therefore, just doing a SUM of the December column is giving an false total.
Can anyone have a look at the attached sheet and see if there is some cunning formula I can use to fix the error.
Note: The values in cells D3:O24 are cumulative values (i.e. the last populated column for each row is the overall total for that project)
Thanks again for any help
I am trying to do a SUM function to simply work out annual totals per project.
However, not all projects ended in December, therefore, just doing a SUM of the December column is giving an false total.
Can anyone have a look at the attached sheet and see if there is some cunning formula I can use to fix the error.
Note: The values in cells D3:O24 are cumulative values (i.e. the last populated column for each row is the overall total for that project)
Thanks again for any help