Sum values between two specified cells in a single column

[larsonsm]

Hi all, I have two worksheets

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>

 

[FDibbins]

I know you said 2 sheets, but you should be able to adapt this...

	A​	B​	C​	D​	E​	F​	G​	H​
1​	ID	Sex	Age1	Age2			Age	Y
2​	12A	m	2	13	71.46​		1	1.11​
3​	12B	m	6	13	49.57​		2	7.26​
4​	12C	f	5	9	25.93​		3	7.32​
5​	12D	m	2	8	45.99​		4	5.74​
6​	12E	f	9	11	13.23​		5	1.57​
7​	12F	m	8	13	33.84​		6	9.47​
8​	12G	f	11	14	24.65​		7	6.26​
9​	12H	m	7	10	20.89​		8	8.37​
10​	12I	f	11	15	24.65​		9	0.26​
11​	12J	f	4	12	47.76​		10	6​
12​							11	6.97​
13​							12	3.12​
14​							13	9.12​
15​							14	5.44​

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