Running Sum of a column with a given Criteria

Kelly Mo

Looking for formula help to provide a running sum of all the guests registered to attend a function on a given day.

Paul Newcome

First thing you will need to do is insert an auto-number column with no special formatting or anything. Then you would use this to get your running totals:

=SUMIFS([# of Guests Registered]:[# of Guests Registered], Date:Date, @cell = Date@row, [Auto-Number Column]:[Auto-Number Column], @cell<= [Auto-Number Column]@row)

Kelly Mo

I added the column with the Auto Number and the formula below but am getting an error: #UNPARSEABLE

=SUMIFS([# Of Guests Attending]:[# Of Guests Attending], Tour Date:Tour Date, @cell = Tour Date@row, [Auto-Number]:[Auto-Number], @cell<=[Auto-Number]@row)

Can you see my error?

Paul Newcome

Any column name with a space, number, and/or special character needs to be wrapped in [square brackets]. Try doing that with each of your [Tour Date] references.