Planned vs Actual Formula

Hi Punnam,

I mapped the formula on my template it looks great though there are still cells that showing an #VALUE!. I really don't know what and how to fix it. Sorry to bother but can you please help me again to perfect the formula.

Also, I observed wrong value for Bruce Wayne for June under Project 10. His allocation was 40 hours and the actual work was 16 hours (if you sum up the Project time (col C) of Bruce for June 30) but we are getting 32 hours (see attached).

Again, thank you in advance for the help.