Brand new to Coda formulas and coming from Excel (which may be my issue).

Let’s say I have the following two column table. First column is an activity and the second column is the associated speed.

What I would like to do is create a nicely summarized table that (minimally) counts the total activities for each speed.

So, 50 would be a count of 3; 60 would be 2 and so on.

I can figure out how to do this just in the text area, but I cannot figure out how to create a table where it is nicely formatted (and upon which I can do some automations).

I figure it’s something basic, but any help is appreciated.

Your formula is different from my formula. I suggested having a {Speed} column in the new table, and then use thisRow.Speed in the formula. You would have to enter a new row for each speed.