# Total amount checked from all records

Solved
885 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi everyone,

I’m working on a table where there are two checkbox fields (yes and no) for each record (employee). I would like to track the total number checked on each checkbox field from all the records. So the total amount of yes and no selected by the employees. There are 100 records (employees) in total. Does anyone have a way to achieve this?

Thanks for the help!

-S

1 Solution

Accepted Solutions
10 - Mercury

Hey there!

Welcome to the Airtable forum!

What you need is a Summary Report.

• You’ll need to create another table in your base. You can call it Reports.

• You’ll also need to add a Rollup field for the YES checkbox and a Rollup for the NO checkbox.

• The formula inside the Rollup field will be SUM(values)

• You’ll then add all your Employee records to a single record in your Reports table. It will automatically calculate the YES and NO totals.

Rollup Field for YES with SUM(values) formula

Reports Table

To understand what a Summary Report is and how to create one, here’s an article

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
3 Replies 3
10 - Mercury

Hey there!

Welcome to the Airtable forum!

What you need is a Summary Report.

• You’ll need to create another table in your base. You can call it Reports.

• You’ll also need to add a Rollup field for the YES checkbox and a Rollup for the NO checkbox.

• The formula inside the Rollup field will be SUM(values)

• You’ll then add all your Employee records to a single record in your Reports table. It will automatically calculate the YES and NO totals.

Rollup Field for YES with SUM(values) formula

Reports Table

To understand what a Summary Report is and how to create one, here’s an article

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
4 - Data Explorer

Thanks Hannah!

I got it working. I really appreciate the help!

10 - Mercury

Awesome! Glad it worked for you!

If you have a minute, would you mind marking it as Solved so others can find a Solution if they need help with the same question?

Have a great day!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable