+ Reply to Thread
Results 1 to 6 of 6

Multiplying cells by various fixed values...

  1. #1
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379

    Multiplying cells by various fixed values...

    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!

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote 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!
    please attach a sample file in zip format.

  3. #3
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Hi there, .zip file uploaded....
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by ChrisMattock
    Hi there, .zip file uploaded....
    data in your file is not according to the description you posted earlier. please make it clear what actually you want to do in your file?

  5. #5
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    if you leave yourself space for the extra rates, say in column e, f ,g etc

    =SUMPRODUCT($A$1:$I$1,A2:I2)

    Regards

    Dav

  6. #6
    Forum Contributor
    Join Date
    04-27-2006
    Location
    Cayman Islands
    Posts
    379
    Thanks! That is perfect!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1