Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIFS - Multiple criteria syntax guidance
I am am struggling to get SUMIFS working with multiple criteria values. I want to sum data based on Month column and then by probability column. Here are a couple methods I have tried but I cannot seem to figure out what I need to do in order to make it work.
=SUMIFS(Month:Month, "March", Probability:Probability, "75%", Revenue:Revenue)
=SUMIFS(Month:Month, "March", Revenue:Revenue, Probability:Probability, "75%")
Ideally I would love to sum all rows that equal march and greater than 75%. Secondly I would like to sum if it is 50-75%.
I cannot seem to make this work.