Dec 27 2021 06:13 AM
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!
Dec 27 2021 06:29 AM - edited Dec 27 2021 06:31 AM
=SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,YourRangeWhereTheValuesAre;">=100")
Dec 29 2021 11:01 AM
Dec 29 2021 12:07 PM
SolutionDec 29 2021 02:08 PM
Dec 29 2021 02:32 PM
Thank you, and the same to you too!
Dec 29 2021 12:07 PM
SolutionTry
=SUMIFS('KT Data'!$M:$M,'KT Data'!$L:$L,'TMS vs KT'!$A3,KT Data'!$M:$M,">100")