Closed Thread
Results 1 to 6 of 6

Alternative to SUMPRODUCT

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    london
    MS-Off Ver
    vista
    Posts
    6

    Alternative to SUMPRODUCT

    Hi,

    I'm currently using a SUMPRODUCT formula to bring back a number where the nominal, year and period match. It just seems some cumbersome. Is there a more efficient command to do this e.g. CHOOSE etc as I need to add another layer for a department condition. I'm just building up a complicated formula that others are struggling to decipher.

    Thanks

    Matt
    Attached Images Attached Images

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Alternative to SUMPRODUCT

    Attach a workbook, not an image - it's really hard to tell what's going on from that picture, and I can't copy your formula (or even see the row / column headings) to see your references...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-07-2016
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    3

    Re: Alternative to SUMPRODUCT

    I need your help ,

    I have a excel sheet
    sheet 1
    41d1366f-c5b6-4afa-b6f7-e99f45befaa6.png

    i want output in sheet 2
    c32027c2-5a84-4028-9369-82b64e0d65a8.png


    Kindly help me sir

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Alternative to SUMPRODUCT

    Quote Originally Posted by elavarasi19 View Post
    I need your help ,

    I have a excel sheet
    sheet 1

    i want output in sheet 2

    Kindly help me sir
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Alternative to SUMPRODUCT

    Quote Originally Posted by elavarasi19 View Post
    .....
    Kindly help me sir
    @ elavarasi19
    Hi elavarasi19

    Welcome to Excel Forum

    You are posting incorrectly

    You must start a new Thread here

    http://www.excelforum.com/excel-programming-vba-macros/
    or here:
    http://www.excelforum.com/excel-general/
    or here:
    http://www.excelforum.com/excel-formulas-and-functions/
    _............................................

    Please take some time before posting to read the Forum Rules here
    Please take some time to read the Rules and Posting Guidelines
    http://www.excelforum.com/forum-rule...rum-rules.html
    http://www.excelforum.com/forums-rules/

    Thanks

    _..............................................

    P.s.
    _B) Please avoid using Images to show a spreadsheet Range.
    Please
    Either:
    Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
    or here:
    http://www.excelforum.com/excel-prog...ml#post4399581
    Practice here:
    http://www.excelforum.com/development-testing-forum/

    OR:
    Upload a Workbook
    : See here:
    http://www.excelforum.com/the-water-...his-forum.html
    http://www.excelforum.com/suggestion...ml#post4335120
    OR:
    There is also the file share site option such as this free thing:
    https://app.box.com/signup/personal
    (_ .Remember to select Share after uploading and give us the link they provide if you use that )
    But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
    For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )
    Practice here:
    http://www.excelforum.com/development-testing-forum/

    And Finally
    Please do not post anymore in my Thread
    http://www.excelforum.com/showthread...t=#post4427939
    http://www.excelforum.com/showthread...t=#post4427932





    Alan
    Last edited by Doc.AElstein; 07-07-2016 at 07:50 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,817

    Re: Alternative to SUMPRODUCT

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Alternative to SUMPRODUCT
    By jiteshmehta2k1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2015, 11:23 PM
  2. Sumproduct Alternative
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2014, 04:57 PM
  3. Alternative to SUMPRODUCT???
    By VTdude12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2011, 04:03 PM
  4. Alternative to SUMPRODUCT?
    By cjrhoads in forum Excel General
    Replies: 26
    Last Post: 05-14-2010, 03:32 PM
  5. Sumproduct alternative
    By DKerr in forum Excel General
    Replies: 6
    Last Post: 01-09-2009, 11:25 AM
  6. Sumproduct - Alternative
    By Harlequin in forum Excel General
    Replies: 2
    Last Post: 08-09-2007, 12:52 PM
  7. Alternative to SUMPRODUCT?
    By staeri@gmail.com in forum Excel General
    Replies: 1
    Last Post: 06-09-2006, 07:10 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