Spreadsheet: 101121d1299259594-adding-several-cells-based-on-content-pvtreadtimeingwithcountsyourdata
Sheet: Rec 03-Event-Data_

 | Participants
Person | Timestamp | Page | Time on Page
1 | 23694 | 1 |  |  |  | No formulas.  Just had to merge you data in a single table, to the left.
1 | 32584 | 2 |  |  |  |  | Participant
1 | 36186 | 3 |  |  |  |  | 1 |  | 2 |  | 3 |  | Total Sum of Time on Page | Total Count of Times
1 | 54424 | 24 |  |  |  | Page | Sum of Time on Page | Count of Times | Sum of Time on Page | Count of Times | Sum of Time on Page | Count of Times
1 | 66271 | 25 |  |  |  | 1 | 12.748 | 2 | 12.383 | 1 | 23.421 | 1 | 48.552 | 4
1 | 73339 | 26 |  |  |  | 2 | 12.147 | 6 | 1.292 | 2 | 5.964 | 2 | 19.403 | 10
1 | 116301 | 25 |  |  |  | 3 | 29.551 | 9 | 15.59 | 6 | 20.592 | 3 | 65.733 | 18
1 | 117099 | 27 |  |  |  | 4 | 3.66 | 4 | 76.73 | 8 | 17.534 | 4 | 97.924 | 16
1 | 120441 | 28 |  |  |  | 5 | 5.845 | 5 | 14.462 | 5 | 11.612 | 5 | 31.919 | 15
1 | 135197 | 27 |  |  |  | 6 | 2.014 | 6 | 4.938 | 6 | 10.426 | 6 | 17.378 | 18
1 | 135561 | 26 |  |  |  | 7 | 3.771 | 7 | 10.844 | 7 | 9.122 | 7 | 23.737 | 21
1 | 136423 | 25 |  |  |  | 8 | 6.935 | 8 | 18.476 | 8 | 12.45 | 8 | 37.861 | 24
1 | 138644 | 24 |  |  |  | 9 | 2.418 | 9 | 168.802 | 9 | 18.174 | 9 | 189.394 | 27
1 | 142224 | 23 |  |  |  | 10 | 2.054 | 10 | 45.29 | 10 | 16.426 | 10 | 63.77 | 30
1 | 145429 | 22 |  |  |  | 11 | 2.18 | 11 | 10.524 | 11 | 21.77 | 11 | 34.474 | 33
1 | 174882 | 21 |  |  |  | 12 | 5.023 | 12 | 5.562 | 12 | 26.9 | 24 | 37.485 | 48
1 | 186481 | 20 |  |  |  | 13 | 1.686 | 13 | 9.564 | 13 | 14.846 | 13 | 26.096 | 39
1 | 198471 | 19 |  |  |  | 14 | 8.736 | 28 | 8.27 | 14 | 8.906 | 14 | 25.912 | 56
1 | 199840 | 18 |  |  |  | 15 | 4.981 | 30 | 5.553 | 15 | 15.814 | 15 | 26.348 | 60
1 | 202974 | 17 |  |  |  | 16 | 3.641 | 32 |  |  | 31.644 | 16 | 35.285 | 48
1 | 204679 | 16 |  |  |  | 17 | 4.833 | 34 |  |  | 13.644 | 17 | 18.477 | 51
1 | 206624 | 15 |  |  |  | 18 | 8.17 | 36 |  |  | 21.23 | 18 | 29.4 | 54
1 | 208384 | 14 |  |  |  | 19 | 4.867 | 38 |  |  | 26.716 | 19 | 31.583 | 57
1 | 211373 | 13 |  |  |  | 20 | 14.066 | 40 |  |  | 10.52 | 20 | 24.586 | 60
1 | 213059 | 12 |  |  |  | 21 | 13.563 | 42 |  |  | 21.296 | 21 | 34.859 | 63
1 | 218082 | 11 |  |  |  | 22 | -364.907 | 66 |  |  | 32.706 | 22 | -332.201 | 88
1 | 220262 | 10 |  |  |  | 23 | 26.607 | 69 |  |  | 12.17 | 23 | 38.777 | 92
1 | 222316 | 9 |  |  |  | 24 | 33.815 | 96 |  |  | 23.802 | 24 | 57.617 | 120
1 | 224734 | 8 |  |  |  | 25 | 16.365 | 125 |  |  | 11.614 | 25 | 27.979 | 150
1 | 231669 | 7 |  |  |  | 26 | 51.91400000000001 | 104 |  |  | 29.66 | 26 | 81.57400000000001 | 130
1 | 235440 | 6 |  |  |  | 27 | 12.864 | 108 |  |  | 12.378 | 27 | 25.242 | 135
1 | 237454 | 5 |  |  |  | 28 | 25.92 | 84 |  |  | 12.702 | 28 | 38.622 | 112
1 | 243299 | 4 |  |  |  | 29 | 17.798 | 58 |  |  | 16.664 | 29 | 34.462 | 87
1 | 246959 | 3 |  |  |  | 30 | 20.394 | 30 |  |  | 13.676 | 30 | 34.07 | 60
1 | 253590 | 2 |  |  |  | 31 |  |  |  |  | 13.932 | 31 | 13.932 | 31
1 | 259867 | 1 |  |  |  | 32 |  |  |  |  | 16.316 | 32 | 16.316 | 32
1 | 263725 | 2 |  |  |  | 33 |  |  |  |  | 9.162 | 33 | 9.162 | 33
1 | 265993 | 3 |  |  |  | 34 |  |  |  |  | 14.078 | 34 | 14.078 | 34
1 | 270675 | 14 |  |  |  | 35 |  |  |  |  | 20.81 | 35 | 20.81 | 35
1 | 276422 | 15 |  |  |  | 36 |  |  |  |  | 18.142 | 36 | 18.142 | 36
1 | 279643 | 16 |  |  |  | 37 |  |  |  |  | 23.752 | 37 | 23.752 | 37
1 | 281339 | 17 |  |  |  | 38 |  |  |  |  | 17.4 | 38 | 17.4 | 38
1 | 284467 | 18 |  |  |  | 39 |  |  |  |  | 22.668 | 39 | 22.668 | 39
1 | 289503 | 19 |  |  |  | 40 |  |  |  |  | 10.88 | 40 | 10.88 | 40
1 | 293001 | 20 |  |  |  | 41 |  |  |  |  | 29.422 | 41 | 29.422 | 41
1 | 295077 | 21 |  |  |  | 42 |  |  |  |  | 18.178 | 42 | 18.178 | 42
1 | 297041 | 22 |  |  |  | 43 |  |  |  |  | 10.762 | 43 | 10.762 | 43
1 | 302981 | 23 |  |  |  | 44 |  |  |  |  | 24.032 | 44 | 24.032 | 44
1 | 310193 | 24 |  |  |  | 45 |  |  |  |  | 13.902 | 45 | 13.902 | 45
1 | 322211 | 25 |  |  |  | 46 |  |  |  |  | 13.226 | 46 | 13.226 | 46
1 | 325807 | 26 |  |  |  | 47 |  |  |  |  | 46.833 | 47 | 46.833 | 47
1 | 331757 | 27 |  |  |  | 48 |  |  |  |  | 24.796 | 48 | 24.796 | 48
1 | 338615 | 28 |  |  |  | 49 |  |  |  |  | 33.532 | 49 | 33.532 | 49
1 | 345335 | 29 |  |  |  | 50 |  |  |  |  | 11.004 | 50 | 11.004 | 50
1 | 356943 | 30 |  |  |  | 51 |  |  |  |  | 8.166 | 51 | 8.166 | 51
1 | 377337 | 29 |  |  |  | Grand Total | -6.341000000000001 | 1122 | 408.28 | 127 | 925.3720000000003 | 1338 | 1327.311 | 2587
1 | 383527 | 28
1 | 387971 | 27
1 | 390271 | 26
1 | 392411 | 25
1 | 395093 | 24
1 | 401463 | 23
1 | 417653 | 22
2 | 17353 | 1 | 12.383
2 | 29736 | 2 | 1.292
2 | 31028 | 3 | 13.818
2 | 44846 | 4 | 75.318
2 | 120164 | 3 | 1.772
2 | 121936 | 4 | 1.412
2 | 123348 | 5 | 14.462
2 | 137810 | 6 | 4.938
2 | 142748 | 7 | 10.844
2 | 153592 | 8 | 18.476
2 | 172068 | 9 | 168.802
2 | 340870 | 10 | 45.29
2 | 386160 | 11 | 10.524
2 | 396684 | 12 | 5.562
2 | 402246 | 13 | 9.564
2 | 411810 | 14 | 8.27
2 | 420080 | 15 | 5.553
3 | 63908 | 1 | 23.421
3 | 87329 | 2 | 5.964
3 | 93293 | 3 | 20.592
3 | 113885 | 4 | 17.534
3 | 131419 | 5 | 11.612
3 | 143031 | 6 | 10.426
3 | 153457 | 7 | 9.122
3 | 162579 | 8 | 12.45
3 | 175029 | 9 | 18.174
3 | 193203 | 10 | 16.426
3 | 209629 | 12 | 2.19
3 | 211819 | 11 | 21.77
3 | 233589 | 12 | 24.71
3 | 258299 | 13 | 14.846
3 | 273145 | 14 | 8.906
3 | 282051 | 15 | 15.814
3 | 297865 | 16 | 31.644
3 | 329509 | 17 | 13.644
3 | 343153 | 18 | 21.23
3 | 364383 | 19 | 26.716
3 | 391099 | 20 | 10.52
3 | 401619 | 21 | 21.296
3 | 422915 | 22 | 32.706
3 | 455621 | 23 | 12.17
3 | 467791 | 24 | 23.802
3 | 491593 | 25 | 11.614
3 | 503207 | 26 | 29.66
3 | 532867 | 27 | 12.378
3 | 545245 | 28 | 12.702
3 | 557947 | 29 | 16.664
3 | 574611 | 30 | 13.676
3 | 588287 | 31 | 13.932
3 | 602219 | 32 | 16.316
3 | 618535 | 33 | 9.162
3 | 627697 | 34 | 14.078
3 | 641775 | 35 | 20.81
3 | 662585 | 36 | 18.142
3 | 680727 | 37 | 23.752
3 | 704479 | 38 | 17.4
3 | 721879 | 39 | 22.668
3 | 744547 | 40 | 10.88
3 | 755427 | 41 | 29.422
3 | 784849 | 42 | 18.178
3 | 803027 | 43 | 10.762
3 | 813789 | 44 | 24.032
3 | 837821 | 45 | 13.902
3 | 851723 | 46 | 13.226
3 | 864949 | 47 | 46.833
3 | 911782 | 48 | 24.796
3 | 936578 | 49 | 33.532
3 | 970110 | 50 | 11.004
3 | 981114 | 51 | 8.166