Sum values between two specified cells in a single column

[larsonsm]

Hi all, I have two worksheets

[TABLE="width: 219"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Sex[/TD]
[TD]Age1[/TD]
[TD]Age2[/TD]
[/TR]
[TR]
[TD]12A[/TD]
[TD]m[/TD]
[TD]2[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]12B[/TD]
[TD]m[/TD]
[TD]6[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]12C[/TD]
[TD]f[/TD]
[TD]5[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]12D[/TD]
[TD]m[/TD]
[TD]2[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]12E[/TD]
[TD]f[/TD]
[TD]9[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]12F[/TD]
[TD]m[/TD]
[TD]8[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]12G[/TD]
[TD]f[/TD]
[TD]11[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]12H[/TD]
[TD]m[/TD]
[TD]7[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]12I[/TD]
[TD]f[/TD]
[TD]11[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]12J[/TD]
[TD]f[/TD]
[TD]4[/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]

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>[TABLE="width: 130"]
<tbody>[TR]
[TD="class: xl65, width: 65"]Age[/TD]
[TD="class: xl66, width: 65"]Y[/TD]
[/TR]
[TR]
[TD="class: xl68"]1[/TD]
[TD="class: xl67, align: right"]1.11[/TD]
[/TR]
[TR]
[TD="class: xl68"]2[/TD]
[TD="class: xl67, align: right"]7.26[/TD]
[/TR]
[TR]
[TD="class: xl68"]3[/TD]
[TD="class: xl67, align: right"]7.32[/TD]
[/TR]
[TR]
[TD="class: xl68"]4[/TD]
[TD="class: xl67, align: right"]5.74[/TD]
[/TR]
[TR]
[TD="class: xl68"]5[/TD]
[TD="class: xl67, align: right"]1.57[/TD]
[/TR]
[TR]
[TD="class: xl68"]6[/TD]
[TD="class: xl67, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="class: xl68"]7[/TD]
[TD="class: xl67, align: right"]6.26[/TD]
[/TR]
[TR]
[TD="class: xl68"]8[/TD]
[TD="class: xl67, align: right"]8.37[/TD]
[/TR]
[TR]
[TD="class: xl68"]9[/TD]
[TD="class: xl67, align: right"]0.26[/TD]
[/TR]
[TR]
[TD="class: xl68"]10[/TD]
[TD="class: xl67, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl68"]11[/TD]
[TD="class: xl67, align: right"]6.97[/TD]
[/TR]
[TR]
[TD="class: xl68"]12[/TD]
[TD="class: xl67, align: right"]3.12[/TD]
[/TR]
[TR]
[TD="class: xl68"]13[/TD]
[TD="class: xl67, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="class: xl68"]14[/TD]
[TD="class: xl67, align: right"]5.44[/TD]
[/TR]
</tbody>[/TABLE]

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>

 

[FDibbins]

I know you said 2 sheets, but you should be able to adapt this...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][/tr]
[tr][td]

1​

[/td][td]ID[/td][td]Sex[/td][td]Age1[/td][td]Age2[/td][td][/td][td][/td][td]Age[/td][td]Y[/td][/tr]

[tr][td]

2​

[/td][td]12A[/td][td]m[/td][td]2[/td][td]13[/td][td]

71.46​

[/td][td][/td][td]1[/td][td]

1.11​

[/td][/tr]

[tr][td]

3​

[/td][td]12B[/td][td]m[/td][td]6[/td][td]13[/td][td]

49.57​

[/td][td][/td][td]2[/td][td]

7.26​

[/td][/tr]

[tr][td]

4​

[/td][td]12C[/td][td]f[/td][td]5[/td][td]9[/td][td]

25.93​

[/td][td][/td][td]3[/td][td]

7.32​

[/td][/tr]

[tr][td]

5​

[/td][td]12D[/td][td]m[/td][td]2[/td][td]8[/td][td]

45.99​

[/td][td][/td][td]4[/td][td]

5.74​

[/td][/tr]

[tr][td]

6​

[/td][td]12E[/td][td]f[/td][td]9[/td][td]11[/td][td]

13.23​

[/td][td][/td][td]5[/td][td]

1.57​

[/td][/tr]

[tr][td]

7​

[/td][td]12F[/td][td]m[/td][td]8[/td][td]13[/td][td]

33.84​

[/td][td][/td][td]6[/td][td]

9.47​

[/td][/tr]

[tr][td]

8​

[/td][td]12G[/td][td]f[/td][td]11[/td][td]14[/td][td]

24.65​

[/td][td][/td][td]7[/td][td]

6.26​

[/td][/tr]

[tr][td]

9​

[/td][td]12H[/td][td]m[/td][td]7[/td][td]10[/td][td]

20.89​

[/td][td][/td][td]8[/td][td]

8.37​

[/td][/tr]

[tr][td]

10​

[/td][td]12I[/td][td]f[/td][td]11[/td][td]15[/td][td]

24.65​

[/td][td][/td][td]9[/td][td]

0.26​

[/td][/tr]

[tr][td]

11​

[/td][td]12J[/td][td]f[/td][td]4[/td][td]12[/td][td]

47.76​

[/td][td][/td][td]10[/td][td]

6​

[/td][/tr]

[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]11[/td][td]

6.97​

[/td][/tr]

[tr][td]

13​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]12[/td][td]

3.12​

[/td][/tr]

[tr][td]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]13[/td][td]

9.12​

[/td][/tr]

[tr][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]14[/td][td]

5.44​

[/td][/tr]
[/table]
G and H would be your 2nd table

E2=SUMIFS($H$2:$H$15,$G$2:$G$15,">="&C2,$G$2:$G$15,"<="&D2)
copied down

 

[larsonsm]

Hi Ford, formula worked perfectly, thanks so much!

 

[FDibbins]

Awesome, happy to help