SUMIF Count to current row possible?

Brad Tippett
Brad Tippett ✭✭
edited 12/07/23 in Formulas and Functions

Hello. Trying to make a formula that counts up until the current row in a column. Using =SUMIF([Month Value]:[Month Value], =MONTH(Date@row), Celebrations:Celebrations) allows me to count all the Celebrations that match the month of the date in the row, which is most of what I want to do. However, I want the total summed to only go up to each row. I.e something along the lines of =SUMIF([Month Value]:[Month Value], =MONTH(Date@row), Celebrations1:Celebrations@row) but when I try this I get an "Incorrect Argument Set" Error. Am I missing something obvious?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!