Forum Discussion
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 value is not equal to or greater than 100 in the sheet labeled "KT Data", I want to exclude it from the comparison that I am making, by also removing the values that are coming from "TMS_Record_Keeping" and "TMS vs KT". The current formula that displays the data are the following:
=SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3)
I'm happy to elaborate further, as I've had a lot of difficulty finding an equivalent online to emulate. Thank you very much!
5 Replies
=SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,YourRangeWhereTheValuesAre;">=100")
- 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!
