Hi all, I have two worksheets
<tbody>
</tbody>
and...
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl64 {text-align:left;}.xl65 {color:windowtext; font-size:11.0pt; text-align:left; background:white; mso-pattern:black none;}.xl66 {color:windowtext; font-size:11.0pt; text-align:right; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; background:white; mso-pattern:black none;}--></style>
<tbody>
</tbody>
From the first worksheet, I have two ages per subject, and I want to calculate the sum of Ys from the second worksheet between and including those two ages. Any Suggestions?<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl64 {color:white; font-size:11.0pt; background:#262626; mso-pattern:black none;}.xl65 {color:white; font-size:11.0pt; text-align:right; background:#262626; mso-pattern:black none;}--></style>
ID | Sex | Age1 | Age2 |
12A | m | 2 | 13 |
12B | m | 6 | 13 |
12C | f | 5 | 9 |
12D | m | 2 | 8 |
12E | f | 9 | 11 |
12F | m | 8 | 13 |
12G | f | 11 | 14 |
12H | m | 7 | 10 |
12I | f | 11 | 15 |
12J | f | 4 | 12 |
<tbody>
</tbody>
and...
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl64 {text-align:left;}.xl65 {color:windowtext; font-size:11.0pt; text-align:left; background:white; mso-pattern:black none;}.xl66 {color:windowtext; font-size:11.0pt; text-align:right; background:white; mso-pattern:black none;}.xl67 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; background:white; mso-pattern:black none;}.xl68 {color:windowtext; font-family:Calibri; mso-generic-font-family:auto; mso-font-charset:0; text-align:left; background:white; mso-pattern:black none;}--></style>
Age | Y |
1 | 1.11 |
2 | 7.26 |
3 | 7.32 |
4 | 5.74 |
5 | 1.57 |
6 | 9.47 |
7 | 6.26 |
8 | 8.37 |
9 | 0.26 |
10 | 6 |
11 | 6.97 |
12 | 3.12 |
13 | 9.12 |
14 | 5.44 |
<tbody>
</tbody>
From the first worksheet, I have two ages per subject, and I want to calculate the sum of Ys from the second worksheet between and including those two ages. Any Suggestions?<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl64 {color:white; font-size:11.0pt; background:#262626; mso-pattern:black none;}.xl65 {color:white; font-size:11.0pt; text-align:right; background:#262626; mso-pattern:black none;}--></style>