+ Reply to Thread
Results 1 to 2 of 2

SUMPRODUCT formula explanation

  1. #1
    Registered User
    Join Date
    02-07-2022
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    1

    SUMPRODUCT formula explanation

    Hi everyone!

    I would like to ask for your help in understanding what does this formula does.

    Formula: =SUMPRODUCT(B2:C16,D2:E16)

    Values from B2 to E16
    63 60 0 0
    65 6 1 1
    84 23 0 0
    27 8 0 1
    20 7 1 0
    2 80 1 0
    42 26 0 0
    28 61 0 0
    87 35 0 1
    32 14 0 0
    53 23 1 0
    1 42 0 1
    39 19 1 1
    41 20 1 0
    21 1 0 1

    Thanks in advance for your help.

    Regards.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: SUMPRODUCT formula explanation

    Hi,

    It takes the product of each corresponding pair in those two arrays, i.e. calculates:

    B2*D2
    B3*D3
    B4*D4
    ...
    B16*D16

    C2*E2
    C3*E3
    C4*E4
    ...
    C16*E16

    and then sums up all those results.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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] How to see formula - explanation please
    By Dumy in forum Excel General
    Replies: 7
    Last Post: 08-01-2015, 06:11 AM
  2. Replies: 1
    Last Post: 08-27-2014, 08:49 PM
  3. Need explanation of this IF formula
    By clm4700 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2013, 05:50 PM
  4. Formula explanation
    By arke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2012, 06:25 AM
  5. formula explanation ?
    By stars in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2012, 06:32 AM
  6. Explanation of formula
    By BRISBANEBOB in forum Excel General
    Replies: 4
    Last Post: 04-03-2009, 03:44 AM
  7. Explanation of SUMPRODUCT
    By Toppers in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-22-2005, 06:06 AM

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