+ Reply to Thread
Results 1 to 2 of 2

Need help with dynamic sumif based on threshold

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    5

    Need help with dynamic sumif based on threshold

    Hi all,

    So I have data for multiple countries based on the share of population number as per different income bands (US$0-500, US$500-1000, ..and so on until population with income of US$250,001+). I need to setup a dynamic summary dashboard with threshold income values using data validation. E.g. if for one country e.g. USA the threshold is US$30k, it returns the sum of population with income of more than US$30k. I know this can be done using SUMIFS by including a new column against income bands for those more than and those less than US$30k, using the criterias.

    But what if the threshold needs to be set as dynamic, and it should return the sum of population numbers with more than the threshold set up validation e.g. US$10k, or $20k or $80K.

    Thanks in advance for the help wonderful community members

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

    Re: Need help with dynamic sumif based on threshold

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. [SOLVED] Output Value Based on Greater than 2% Threshold
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2019, 03:40 AM
  2. Dynamic sumif based on changing list of inclusion criteria?
    By Oppo28 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2017, 04:28 PM
  3. Change threshold based on a fixed sum
    By cpar211 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2017, 03:43 PM
  4. Replies: 1
    Last Post: 11-30-2016, 08:02 PM
  5. [SOLVED] automating sumproduct based on dynamic total (a sumif formula)
    By jim808 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-19-2016, 05:40 AM
  6. Project Status based on threshold
    By Burridge13 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-19-2015, 08:17 AM
  7. Dynamic sumif ranges based on Hlookup criteria
    By Dial1 in forum Excel General
    Replies: 2
    Last Post: 10-24-2011, 01:21 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