+ Reply to Thread
Results 1 to 6 of 6

Formula to find sum of unique values related to month chosen from dropdown

  1. #1
    Registered User
    Join Date
    11-29-2023
    Location
    Ottawa, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Formula to find sum of unique values related to month chosen from dropdown

    I'm trying to make a formula that will count the unique number of values within a specific month that is chosen from a dropdown. Basically there will be an input form where people enter a location number and the month they went, and then I want a summary section where you can choose which month to view, and it will add up the sum of the unique locations visited that month. I've made a small example in my attached file.

    Using my attached file as reference, when I've selected January from the month dropdown in B1, I would want B3 to show "2", since there are 2 unique location values for January. Similarly, if I changed the month dropdown to February, I would want B3 to show "3", since there are 3 unique locations values for that month.

    I was able to easily do something similar with the =SUMIF function when I was counting the total number of visits at each location, but I'm assuming for this I need =COUNTIF or =COUNTIFS and I just can't figure it out. Hopefully all the information needed is here and in the attached.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula to find sum of unique values related to month chosen from dropdown

    Hi and welcome
    what XL version is 2309 please?

  3. #3
    Registered User
    Join Date
    11-29-2023
    Location
    Ottawa, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Re: Formula to find sum of unique values related to month chosen from dropdown

    Thank you.

    Microsoft 365

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula to find sum of unique values related to month chosen from dropdown

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-29-2023
    Location
    Ottawa, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    3

    Re: Formula to find sum of unique values related to month chosen from dropdown

    Works perfectly!

    Thank you so much Pepe. I was trying to ask in Reddit for help with this but my posts kept being auto flagged as spam and deleted. I am very happy to have found this forum and will return if I need to.

    Thanks again.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula to find sum of unique values related to month chosen from dropdown

    You're welcome and thanks for the rep
    BTW this place is MUCH better than others for XL questions. There are some fantastic people out here

+ 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: 27
    Last Post: 10-17-2022, 02:20 PM
  2. Replies: 2
    Last Post: 08-25-2021, 12:34 AM
  3. VBA to find unique values in one sheet that have no related values in another sheet
    By theDavidErickson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2016, 05:13 PM
  4. [SOLVED] Formula or VBA - Comparison CSV Values between 3 cells for used range. Find unique values.
    By grphillips in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 06-09-2014, 02:12 PM
  5. Replies: 12
    Last Post: 02-08-2013, 02:26 PM
  6. Simple Macro - Sum of values that are related to a sprecific word chosen by you.
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-02-2012, 03:31 PM
  7. Increasing Values by % chosen from a dropdown list/box.
    By jmadsen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2011, 11:28 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