+ Reply to Thread
Results 1 to 2 of 2

display sumifs items

  1. #1
    Registered User
    Join Date
    03-08-2016
    Location
    Fyn, Denmark
    MS-Off Ver
    2010
    Posts
    4

    display sumifs items

    Hi,

    I've been looking a this thread: http://www.excelforum.com/showthread.php?t=754662
    I've a similar request, I just need the items from a sumifs function instead of sumif.

    I have 4 criterias in my sumifs and need it displayed directly in cells, instead of a messagebox.

    I'm not sure, if this is possible. Anyone you who can confirm if this is possible?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: display sumifs items

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the 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. Need help to auto display BOM items.
    By excelhelp90 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2016, 05:22 AM
  2. Sumifs when there are several line items
    By Alex.Venables20 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2015, 06:00 AM
  3. [SOLVED] sumifs excluding certain items
    By Tradesman in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-30-2014, 02:17 AM
  4. Multiple items on criteria for SUMIF (but not with SUMIFS)
    By Pullo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2014, 01:17 PM
  5. [SOLVED] SUMIF or SUMIFS to find text and date between from items in a table
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2014, 10:38 PM
  6. Click Sumifs total to display associated detail table data
    By Jim Boyd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2012, 05:32 PM
  7. Replies: 10
    Last Post: 03-01-2012, 01:20 PM

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