Hi
Hoping someone can help me out here as i am by no means an excel expert, and i'm having some problems with a formula on a workbook i'm using.
On one tab, i have a list of resources and if they are "Direct Staff Cost" or "Insourced Cost", the columns to the right of this is then split up per week with the number of days that resource is working on a project.
I then have a second tab that i'm using to compare the estimated total for a month vs the actual time spent.
I originally was using the following formula
Formula:Please Login or Register to view this content.
This would look on the "Resource_Plan" tab and Column D for the word "Direct Staff Cost", if found it would then look at the resource plan tab and total up the number of days in H11:L85. Then finally divide it by 20 to work out the Person Month planned cost for that month. But what i'm finding is that its either only summing up the first column (H11:H85) or returning something wildly out of scope.
After abit of googling i came across a similar formula using the SUMPRODUCT functions.
Formula:Please Login or Register to view this content.
Before using this formula on the EstvsActuals tabs i tested it out at the bottom of the resource plan tab (without the reference to the resource plan) and it appears to give me the correct results. But now i've copied it to the tab i need the formula on its giving me the result of "#N/A" and i cant figure out why or what is going wrong.
Can anyone provide some assistance on what i'm doing wrong.
Bookmarks