Spreadsheet: 873584d1720095424-total-percentage-for-all-the-percentages-for-columns-rows-columns-and-rows-kpi
Sheet: Sheet1

Name | : Person #1
Month | : MonthName |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
No. | KPI Items Title | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | %
1 | KPI #1 | 24 | 13 | 10 | 6 | 19 | 4 | 7 | 7 | 3 | 10 | 8 | 1 | 13 | 13 | 19 | 4 | 8 | 24 | 3 | 2 | 22 | 12 | 16 | 19 | 7 | 22 | 4 | 11 | 2 | 10 | 18 | 14 |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here I want to calculate the total percentage of the entire month for the KPI Item for the 31 days, I mean for the entire row, in other words, what is the total % for the enntire month out of 100% for that KPI ITEM?
2 | KPI #2 | 32 | 31 | 32 | 27 | 3 | 11 | 20 | 3 | 23 | 18 | 15 | 7 | 18 | 27 | 24 | 25 | 20 | 23 | 24 | 17 | 23 | 25 | 2 | 31 | 6 | 5 | 3 | 10 | 15 | 13 | 5 | 10 |  | 32
3 | KPI #3 | 26 | 20 | 4 | 8 | 25 | 22 | 21 | 14 | 5 | 23 | 18 | 21 | 20 | 15 | 20 | 15 | 21 | 14 | 9 | 21 | 23 | 21 | 4 | 24 | 12 | 19 | 25 | 21 | 3 | 11 | 3 | 20 |  | 26
4 | KPI #4 | 19 | 16 | 17 | 17 | 18 | 5 | 8 | 12 | 16 | 10 | 18 | 18 | 5 | 11 | 7 | 19 | 4 | 16 | 19 | 6 | 9 | 18 | 13 | 10 | 13 | 16 | 12 | 9 | 15 | 13 | 10 | 17 |  | 19
5 | KPI #5 | 15 | 12 | 10 | 5 | 6 | 12 | 13 | 5 | 8 | 5 | 12 | 8 | 9 | 9 | 13 | 13 | 12 | 10 | 10 | 11 | 12 | 10 | 5 | 6 | 11 | 8 | 9 | 11 | 6 | 6 | 13 | 12 |  | 15
6 | KPI #6 | 22 | 12 | 9 | 13 | 10 | 18 | 18 | 16 | 11 | 6 | 13 | 19 | 19 | 8 | 22 | 21 | 15 | 18 | 9 | 20 | 15 | 22 | 21 | 9 | 15 | 21 | 15 | 22 | 10 | 13 | 10 | 21 |  | 22
7 | KPI #7 | 17 | 16 | 7 | 8 | 10 | 11 | 11 | 8 | 16 | 13 | 12 | 12 | 12 | 8 | 8 | 9 | 12 | 16 | 16 | 16 | 13 | 10 | 12 | 15 | 10 | 16 | 17 | 11 | 16 | 16 | 10 | 15 |  | 17
8 | KPI #8 | 23 | 8 | 12 | 13 | 19 | 20 | 13 | 20 | 9 | 19 | 22 | 22 | 8 | 8 | 10 | 14 | 13 | 17 | 17 | 18 | 18 | 15 | 17 | 9 | 11 | 22 | 23 | 20 | 20 | 8 | 10 | 18 |  | 23
9 | KPI #9 | 16 | 13 | 9 | 13 | 16 | 10 | 9 | 15 | 14 | 15 | 15 | 13 | 15 | 14 | 12 | 11 | 10 | 10 | 10 | 14 | 12 | 10 | 16 | 12 | 13 | 9 | 12 | 16 | 11 | 10 | 15 | 10 |  | 16
10 | KPI #10 | 20 | 18 | 14 | 12 | 20 | 17 | 10 | 10 | 11 | 19 | 17 | 15 | 18 | 14 | 19 | 18 | 18 | 12 | 15 | 20 | 19 | 10 | 13 | 17 | 16 | 11 | 16 | 13 | 10 | 15 | 10 | 13 |  | 20
11 | KPI #11 | 28 | 14 | 23 | 17 | 14 | 20 | 27 | 21 | 22 | 13 | 13 | 26 | 26 | 13 | 11 | 18 | 23 | 13 | 26 | 12 | 16 | 25 | 14 | 27 | 16 | 17 | 14 | 17 | 27 | 14 | 18 | 13 |  | 28
12 | KPI #12 | 33 | 16 | 29 | 22 | 21 | 15 | 32 | 26 | 15 | 16 | 27 | 20 | 22 | 26 | 23 | 17 | 24 | 33 | 28 | 25 | 27 | 16 | 25 | 32 | 17 | 18 | 17 | 16 | 18 | 16 | 19 | 32 |  | 33
13 | KPI #13 | 29 | 17 | 20 | 23 | 15 | 13 | 14 | 17 | 25 | 15 | 22 | 28 | 19 | 15 | 17 | 14 | 19 | 13 | 26 | 26 | 27 | 27 | 25 | 13 | 25 | 27 | 18 | 19 | 24 | 21 | 24 | 16 |  | 29
14 | KPI #14 | 30 | 25 | 17 | 29 | 23 | 20 | 24 | 25 | 16 | 22 | 25 | 20 | 25 | 14 | 29 | 18 | 14 | 19 | 20 | 18 | 22 | 25 | 22 | 17 | 17 | 22 | 21 | 18 | 30 | 24 | 18 | 17 |  | 30
15 | KPI #15 | 25 | 23 | 17 | 15 | 15 | 18 | 16 | 21 | 23 | 16 | 21 | 25 | 16 | 17 | 20 | 18 | 22 | 20 | 21 | 21 | 24 | 17 | 18 | 21 | 17 | 24 | 24 | 22 | 25 | 19 | 17 | 21 |  | 25
16 | KPI #16 | 31 | 16 | 21 | 20 | 23 | 22 | 28 | 28 | 27 | 28 | 30 | 23 | 18 | 17 | 30 | 20 | 19 | 16 | 23 | 19 | 24 | 23 | 18 | 24 | 30 | 19 | 28 | 16 | 26 | 22 | 30 | 19 |  | 31
17 | KPI #17 | 18 | 18 | 17 | 17 | 18 | 18 | 18 | 17 | 17 | 18 | 17 | 17 | 18 | 17 | 17 | 17 | 18 | 18 | 18 | 17 | 18 | 18 | 18 | 17 | 17 | 17 | 18 | 17 | 18 | 17 | 17 | 18 |  | 18
18 | KPI #18 | 24 | 21 | 21 | 22 | 20 | 21 | 20 | 18 | 18 | 24 | 20 | 22 | 20 | 18 | 24 | 18 | 23 | 20 | 20 | 22 | 24 | 24 | 21 | 20 | 18 | 23 | 21 | 20 | 24 | 19 | 19 | 18 |  | 24
19 | KPI #19 | 21 | 20 | 21 | 20 | 21 | 21 | 21 | 21 | 19 | 20 | 19 | 21 | 20 | 19 | 21 | 19 | 21 | 20 | 21 | 21 | 19 | 19 | 20 | 19 | 21 | 20 | 20 | 20 | 19 | 19 | 21 | 20 |  | 21
20 | KPI #20 | 27 | 20 | 22 | 23 | 20 | 24 | 22 | 26 | 20 | 27 | 22 | 24 | 25 | 21 | 20 | 26 | 26 | 25 | 23 | 25 | 20 | 22 | 27 | 23 | 26 | 21 | 20 | 27 | 22 | 23 | 25 | 22 |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here I want to calculate the total percentage of the entire day for all the KPI Items for the entire day, I mean for the entire column, in other words, what is the total % for the enntire day out of 100% for that day? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here I want to do the same for both the columns and rows for entire month for all KPIs, out of 100%