+ Reply to Thread
Results 1 to 4 of 4

SUMPRODUCT Of Multiple Cell

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Iran, Ahvaz
    MS-Off Ver
    Excel 2007-2010-2013
    Posts
    12

    Question SUMPRODUCT Of Multiple Cell

    Hello Friend's
    I Want Use SUMPRODUCT Formula in file that i attached
    can anybody help me plz ?

    tnx
    sump.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,893

    Re: SUMPRODUCT Of Multiple Cell

    You could do it this way:

    =SUMPRODUCT((LEN(A13:A47)=LEN(A13))*(C13:C47)*(D13:D47))

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-14-2014
    Location
    Iran, Ahvaz
    MS-Off Ver
    Excel 2007-2010-2013
    Posts
    12

    Re: SUMPRODUCT Of Multiple Cell

    Its Help Me
    The point of this file is the activity ID

    Thank you so much

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,893

    Re: SUMPRODUCT Of Multiple Cell

    Glad to help.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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: 02-21-2014, 09:09 PM
  2. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  3. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  4. How to put multiple Sumproduct formulas in one cell
    By jimstrongy in forum Excel General
    Replies: 6
    Last Post: 12-30-2011, 01:50 PM
  5. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 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