Originally Posted by
ChrisMattock
Across Row 1, from column B to column D, runs a list of rates i.e. £10 ph, £30 ph etc.
Down Column A, from row 2 to row 10, runs a list of projects.
In B2:D10 hours are inputted for each rate against each project.
In column E, from row 2 to 10, is the Total Project Cost (Currency). This is where the problem lies. Currently I have the following...
E2 =B2*B$1+C2*C$1+D2*D$1
E3 =B3*B$1+C3*C$1+D3*D$1
E4 =B4*B$1+C4*C$1+D4*D$1
Obviously this is not ideal and as more rates are added and more projects created it gets even more complex. Is there a simpler way of doing this please?
THANKS!
Bookmarks