+ Reply to Thread
Results 1 to 4 of 4

Excel Multiplication

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    India
    MS-Off Ver
    Microsoft Office 2016
    Posts
    3

    Question Excel Multiplication

    Hello Friends,
    Can you please help me regarding the formula in Cell D54, is there any way out to automate and drag it till cell Q57 instead of doing manual multiplication.
    Please help.

    Multipication.png
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    6,869

    Re: Excel Multipication

    Please try at D54
    =SUMPRODUCT(D3:D48*D4:D49,--($C$3:$C$48=$C$3))/D53
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,605

    Re: Excel Multiplication

    With reference to the post #2 formula: Is it divide by D53 or should it be D$53 ??

    I'm thinking that the divisor possibly should be "Production quantity" (row 53) for all four cost types in "Group".
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select “Solved” from the Thread Tools menu

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    EXCEL 2007/365
    Posts
    1,869

    Re: Excel Multiplication

    D53 cell formula , Drag right

    HTML Code: 
    SUMIF($C$3:$C$52,$C$53,D$3)

    D54 cell formula , Drag down and accross
    HTML Code: 
    =SUMPRODUCT(($C$3:$C$48=$C$53)*D$3:D$48,($C4:$C49=$C54)*D4:D49)/D$53

+ 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. [SOLVED] Multiplication excel code formula
    By RJ1969 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2018, 04:50 PM
  2. [SOLVED] Excel multiplication
    By Joshua114 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-24-2016, 08:38 AM
  3. How to do Reverse Multiplication In Excel?
    By AxleHead in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 12:51 PM
  4. [SOLVED] Multiplication Bug - Excel (Office) 2010
    By mgs in forum Excel General
    Replies: 5
    Last Post: 05-05-2014, 03:09 AM
  5. Excel Multiplication Miscalculation
    By yawnzzzz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-02-2011, 05:11 PM
  6. multiplication formula in excel
    By v.muruganandam in forum Excel General
    Replies: 2
    Last Post: 07-25-2009, 01:30 AM
  7. [SOLVED] Matrix Multiplication:Excel SOMETIMES
    By Matrix Bill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 02:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1