Combine row of data for total

Ask for Help
1

Hi community. My first post. I am working on a tracker of all the football games I have attended to try find all my stats. I am currently struggling to total the amount of data into 1 specific output

ref
ref2118Ă—1137 166 KB

I want to total the amount of yellow cards and then I want to total the amount of games so I have single total numbers to know I have seen X number of games and X number of yellow cards. Any help would be appreciated. Thanks!

2

You can use Rollup Columns.

3

Thanks for the fast reply Darren. Are you sure that a Rollup will work?

I want the total number of all the yellow cards per referee put together so I have 1 total and I want the total number of all the games per referee put together so I have 1 total.

ref 1.PNG
ref 1.PNG2126Ă—1188 145 KB

Above is an image of a breakdown of one season where I have unhidden the columns. As you can see I have used a look up to find the data per column, then used a rollup to count that data and then done a total ( 08 09 YC 1 Roll + 08 09 YC 2 Roll)

4

If you want totals, averages, counts, etc.: use a rollup column which will give you the total, average, count of that entire column.

If you want conditional totals, averages, counts, etc. (i.e. “per something”): use a query column first to define your condition, and then do a rollup on the query column.

5

Well, you didn’t say that the first time.

To get that, do what Nathanael suggested.

6

Thanks very much Nathanael for your help that seems to have done it. Much appreicated :slight_smile:

Thanks Darren for your help also