Forum Discussion

GarrettAI's avatar
GarrettAI
Copper Contributor
Dec 27, 2021
Solved

Trying to Add a Minimum value to SUMIFS formula

Hi there, I'm currently trying to add a minimum value to my SUMIFS formula. The idea is to exclude data points if they are not above a certain value, such as 100. For example, in my file, if the valu...
BI & Data Analysis
excel
Excel on Mac
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 29, 2021

    GarrettAI 

    Try

     

    =SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,KT Data'!$M:$M,">100")

Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Dec 27, 2021

=SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,YourRangeWhereTheValuesAre;">=100")

GarrettAI's avatar
GarrettAI
Copper Contributor
Dec 29, 2021
hi Juliano, thank you for responding the other day with that. I've been trying to implement it but I can't seem to get it to work. where you said ' YourRangeWhereTheValuesAre; ' is that referring to the location, as in the sheet, where the values are, or the actual range that I want to analyze, which in this case is anything over 100?

Thanks again for the help, really appreciate it!
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 29, 2021

    GarrettAI 

    Try

     

    =SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,KT Data'!$M:$M,">100")

    • GarrettAI's avatar
      GarrettAI
      Copper Contributor
      Dec 29, 2021
      Hans! It worked!!! Thank you so much!!! Happy New Year and may it be a great one, man!