SUMIF Count to current row possible?

Brad Tippett

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?

Paul Newcome

You need the range sizes to match. If you are doing

Celebrations1:Celebrations@row

then you also need to have

[Month Value]1:[Month Value]@row

Paul Newcome

You need the range sizes to match. If you are doing

Celebrations1:Celebrations@row

then you also need to have

[Month Value]1:[Month Value]@row

Brad Tippett

@Paul Newcome that worked, thank you so much!

Paul Newcome

Happy to help. 👍️