+ Reply to Thread
Results 1 to 5 of 5

drop down list using all function

  1. 12-13-2018, 01:54 AM #1
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    drop down list using all function

    Dear friends,
    I am using excel 2010. I need one help. I using sumifs formula in my sheet its working fine. But I need now used drop down list when I select in list values is get but I need get full report I will add in that list ALL I want get full report.how to get please give me one solution.
    Reply With QuoteRegister To Reply
  2. 12-13-2018, 01:55 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: drop down list using all function

    No idea from your description! Please provide some examples of what you mean.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 12-13-2018, 02:25 AM #3
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    Re: drop down list using all function

    i attached sample sheet

    please find the attachedtest.xlsx

    i select all in drop down list i want get full count
    Attached Files Attached Files
    Last edited by sudbhavani; 12-13-2018 at 03:18 AM.
    Reply With QuoteRegister To Reply
  4. 12-13-2018, 05:26 AM #4
    sudbhavani
    sudbhavani is offline
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    Re: drop down list using all function

    Dear friend,

    i find some vba code for this but now formula is not working.kindly check with this formula and give one solution.

    i attached sample file test.xlsm

    please give me one idea? please please
    Attached Files Attached Files
    Last edited by sudbhavani; 12-13-2018 at 05:44 AM.
    Reply With QuoteRegister To Reply
  5. 12-13-2018, 07:49 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: drop down list using all function

    I first changed your dropdown to get rid of all the duplicates.

    In Q1: All
    In Q2, copied down to Q20:
    =IFERROR(INDEX(Sheet2!$N$2:$N$1000,MATCH(0,INDEX(COUNTIF($Q$1:$Q1,Sheet2!$N$2:$N$1000),0),0)),"")

    I then used a named range (called "List", use CTRL-F3 to view/edit) with this formula:
    =Sheet1!$Q$1:INDEX(Sheet1!$Q$1:$Q$20,SUMPRODUCT(--(LEN(Sheet1!$Q$1:$Q$20)>0)))

    I then used this formula in , and dragged it down:

    =SUMIFS(Sheet2!$O:$O,Sheet2!$B:$B,">="&$E$2,Sheet2!$B:$B,"<="&$G$2,Sheet2!$N:$N,IF($B$4="All","<>",$B$4),Sheet2!$J:$J,Sheet1!$B$7,Sheet2!$L:$L,Sheet1!B$9,Sheet2!$D:$D,Sheet1!$A10)
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Drop Down List with an IF function?
    By AmMiller in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-01-2016, 03:38 PM
  2. Drop down list Sum Function
    By Tankerblade in forum Excel General
    Replies: 8
    Last Post: 06-02-2016, 07:01 AM
  3. [SOLVED] IF function with drop-down list
    By hobo1999 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2015, 02:30 PM
  4. Drop Down List Function
    By salmanjan in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-23-2014, 08:05 PM
  5. Drop down list dependant on IF function
    By Julian Philips in forum Excel General
    Replies: 1
    Last Post: 03-18-2013, 09:11 AM
  6. [SOLVED] IF Function Return Drop-Down List
    By bRob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2012, 05:32 PM
  7. IF function and a drop down list validation.
    By Stevie-B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2008, 02:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1