+ Reply to Thread
Results 1 to 3 of 3

Working out product across multiple columns?

Hybrid View

  1. 07-02-2013, 07:21 AM #1
    Aidan Leather
    Aidan Leather is offline
    Registered User
    Join Date
    07-02-2013
    Location
    Stratford-upon-Avon, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Working out product across multiple columns?

    Hi all,

    I've been trying to figure out what formula will allow me to calculate the product of row L and whichever column has a value between row E and K, but to no avail. I'm looking for a formula that can be copied into the below boxes, to save time writing new formulas for each row.

    Excel.jpg

    Any help would be much appreciated,

    Thanks,
    Aidan
    Attached Images Attached Images
    Last edited by Aidan Leather; 07-02-2013 at 07:24 AM.
    Reply With QuoteRegister To Reply
  2. 07-02-2013, 07:25 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Working out product across multiple columns?

    If its only 1 entry in columns E:K

    =L10*sum(E10:K10)
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 07-02-2013, 07:31 AM #3
    Aidan Leather
    Aidan Leather is offline
    Registered User
    Join Date
    07-02-2013
    Location
    Stratford-upon-Avon, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Working out product across multiple columns?

    Thanks, has worked perfectly!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1