I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next entry in the row AFTER the reference in the formula. If I indicate the rows to be counted are only the populated ones, the Summary doesn't work. It doesn't make sense to me because this is how the template is supposed to function.
For instance: If I indicate the entries to be counted are B22: B62, Smartsheet puts the next entry at B63 even though all the other rows are blank. If I indicate the rows to be counted are B22:B25 (because they are populated) Smartsheet correctly puts the next entry at B26 but the Summary does not work. (see screenshot) . What am I doing wrong?
Any help is greatly appreciated.
