How to generate a % score at the bottom of a table

Calculating a percent score at the bottom of a prefilled table is simple.

There are two ways you can do this:

If your data set to calculate the % score is in a default table, use a separate (prefilled) table as your summary display.
If your data set is already in a prefilled table, you can use the same table to have your display cell.

To start, navigate your cursor to the left tab and choose either of which table.

For example:

In a default table:

Suppose you have an audit report and the questions are rated from 1-5, and the scoring system is based off of the summary of those scores. In finding the percentage score, you divide the total to the maximum score.

Score table (Default table)

Question	Score (1-5)	Comments
	(B1 - number field)

In your summary table (prefilled table)

Use the formula in your display cell,

=SUM(Table1!B:B)/COUNTA(Table1!A:A)*100

% Score	Comments
=SUM(Table1!B:B)/COUNTA(Table1!A:A)*100

In a prefilled table:

Set your table such that the last two rows are intended for the sum and percent of total sum. You can use a different arrangement of your preference.

Given the table of total sales from Q1-Q4 of Products 1, 2, and 3:

	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Product 1	1000	1500	750	850	4100
Product 2	1500	1000	1000	900	4400
Product 3	1000	750	1500	850	4100
Total	3500	3250	3250	2600	*12600*
% of Total

Use the SUM() Formula to calculate the sums of each quarter column.

Q1_Total = 3500 --> Cell B5
```
=SUM(B2:B4)
```
Q2_Total = 3250 --> Cell C5
```
=SUM(C2:C4)
```
Q3_Total = 3250 --> Cell D5
```
=SUM(D2:D4)
```
Q4_Total = 2600 --> Cell E5
```
=SUM(E2:E4)
```

	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Product 1	1000	1500	750	850	4100
Product 2	1500	1000	1000	900	4400
Product 3	1000	750	1500	850	4100
Total	3500	3250	3250	2600	12600
% of Total	27.78%	25.79%	25.79%	20.63%	100%

Given that,

Annual_Total = 12600 --> Cell F5

To calculate for the quarter percentages over the annual total, use the formula:

=(Q_n_Total/Annual_Total)*100

% Q1 = 3500 --> Cell B6
```
=(Q1_Total/Annual_Total)*100
```
% Q2 = 3250 --> Cell C6
```
=(Q2_Total/Annual_Total)*100
```
% Q3 = 3250 --> Cell D6
```
=(Q3_Total/Annual_Total)*100
```
% Q4 = 2600 --> Cell E6
```
=(Q4_Total/Annual_Total)*100
```