+ Reply to Thread
Results 1 to 4 of 4

Multiply rows with a value before adding.

  1. #1
    Registered User
    Join Date
    07-04-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    5

    Multiply rows with a value before adding.

    Hi All,
    Can anyone help me to get a best formula in completing my task.

    I have few rows, the first row will have a value of 0 or 1 and its static other rows will have any numeric values
    I need to multiply each row with the first row and finally sum the values in a cell

    for example
    A B C D D E F G H I...
    Row 1 --- 1 0 1 0 1 0 0...n
    Row 2 ---- 4 8 9 9 4 0 1..n
    Row 3 ---- 5 6 7 8 7 6 5 4..n
    Row 4---- 9 0 3 4 5 6 7 8..n

    If know I can add something like

    B1=C1*C2+D1*D2+E1*E2+F1*F2+G1*G2+H1*H2+I1*I2*J1*J2*K1*K2+L1*L2......
    B2=C1*C3+D1*D3+E1*E3+F1*F3+G1*G3+H1*H3+I1*I3+J1*J3+K1*K3+L1*L3
    B3=C1*C4+D1*D4+E1*E4+F1*F4+G1*G4+H1*H4+I1*I4+J1*J4+K1*K4+L1*L4

    but I need to have this till end of the sheet. so the formula looks clumsy.
    Is there any formula in excel to do perform this task without macros.

    Thanks,
    Ravi
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: Multiply rows with a value before adding.

    Hi, theree is a slight mistake in the formula in row 2. The answer should be 68.

    You need to use SUMPRODUCT in B2, & copy down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    07-04-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    5

    Re: Multiply rows with a value before adding.

    Thankyou Glenn Kennedy, It worked perfect. Appreciate your quick response.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: Multiply rows with a value before adding.

    You're welcome. Can you now mark the thread as closed and (preferably) say thanks by clicking the Add Reputation button at the foot of this post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-24-2014, 06:20 PM
  2. [SOLVED] Adding multiply taxes to cell
    By Treecko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-05-2013, 09:15 PM
  3. multiply several different rows in a colum beginner
    By gt5228 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2013, 01:31 AM
  4. Multiply Rows By 365
    By marinos.a in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-11-2010, 04:02 PM
  5. Adding & Multiply various txt..value in userform
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2010, 01:22 AM

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