zlockbag1869
New Member
- Joined
- Sep 30, 2015
- Messages
- 2
Good Evening,
Not sure if I am phrasing the question right, but I am trying to figure out if there is a way to remove column C and still have column B subtract initially from the total number and then descend from there. (i.e. 151-4 and getting the percent surviving from that in column D. Then 147-24, rather then 151-24.) I can't seem to figure out a way to create a formula without having the C column in which to properly calculate the subtraction. Any help would be GREATLY appreciated!!!! Current formula is : =C8/$C$6*100
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Not sure if I am phrasing the question right, but I am trying to figure out if there is a way to remove column C and still have column B subtract initially from the total number and then descend from there. (i.e. 151-4 and getting the percent surviving from that in column D. Then 147-24, rather then 151-24.) I can't seem to figure out a way to create a formula without having the C column in which to properly calculate the subtraction. Any help would be GREATLY appreciated!!!! Current formula is : =C8/$C$6*100
| A | B | C | D | E | F | G |
| Pre 1900 Cemetary data | ||||||
| Males | Females | |||||
| Age at death | # died | # survivers | % surviring | # died | # survivers | % surviring |
| Live Birth | 0 | 151 | 100 | 0 | 117 | 100 |
| 0 – 0.99 | 4 | 147 | 97.35 | 3.00 | 114.00 | 97.44 |
| 1 – 4.99 | 24 | 123 | 81.46 | 23.00 | 91.00 | 77.78 |
| 5 – 9.99 | 7 | 116 | 76.82 | 6.00 | 85.00 | 72.65 |
| 10 – 14.99 | 3 | 113 | 74.83 | 4.00 | 81.00 | 69.23 |
| 15 – 19.99 | 5 | 108 | 71.52 | 8.00 | 73.00 | 62.39 |
| 20 – 24.99 | 9 | 99 | 65.56 | 11.00 | 62.00 | 52.99 |
| 25 – 29.99 | 9 | 90 | 59.60 | 2.00 | 60.00 | 51.28 |
| 30 – 34.99 | 13 | 77 | 50.99 | 6.00 | 54.00 | 46.15 |
| 35 – 39.99 | 11 | 66 | 43.71 | 5.00 | 49.00 | 41.88 |
| 40 – 44.99 | 14 | 52 | 34.44 | 6.00 | 43.00 | 36.75 |
| 45 – 49.99 | 13 | 39 | 25.83 | 3.00 | 40.00 | 34.19 |
| 50 – 54.99 | 8 | 31 | 20.53 | 5.00 | 35.00 | 29.91 |
| 55 – 59.99 | 3 | 28 | 18.54 | 6.00 | 29.00 | 24.79 |
| 60 – 64.99 | 10 | 18 | 11.92 | 8.00 | 21.00 | 17.95 |
| 65 – 69.99 | 4 | 14 | 9.27 | 8.00 | 13.00 | 11.11 |
| 70 – 74.99 | 9 | 5 | 3.31 | 5.00 | 8.00 | 6.84 |
| 75 – 79.99 | 3 | 2 | 1.32 | 5.00 | 3.00 | 2.56 |
| 80 – 84.99 | 2 | 0 | 0.00 | 1.00 | 2.00 | 1.71 |
| 85 – 89.99 | 0 | 0 | 0.00 | 1.00 | 1.00 | 0.85 |
| 90 – 94.99 | 0 | 0 | 0.00 | 0.00 | 1.00 | 0.85 |
| 95 – 99.99 | 0 | 0 | 0.00 | 1.00 | 0.00 | 0.00 |
| Over 100 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total | 151 | 117 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
