Sumifs with range

[confusedexcel4]

Hello! I am trying to find the total of column's C, D and E if column A falls in a specific range. I figured out how to get the total files if A is >=10 and >=23 but I can not get the total files if A is 11-22. ~ Thank you in advance for your help!

A	B	C	D	E
		A files	B files	Completed files
2	Tues	266	290	176
3	Wed	232	261	170
4	Thurs	249	281	167
5	Fri	124	145	133
8	Mon	160	201	145
9	Tues	295	313	246
10	Wed	254	268	187
11	Thurs	119	155	178
12	Fri	236	253	149
16	Tues	280	296	166
17	Wed	287	306	179
18	Thurs	283	308	214
19	Fri	205	228	197
22	Mon	198	230	231
23	Tues	333	344	237
24	Wed	344	352	216
25	Thurs	264	278	242
26	Fri	262	271	277
29	Mon	273	284	207
30	Tues	371	377	191
31	Wed	130	143	221

<colgroup><col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;"> <col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"> <col width="45" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <tbody> </tbody>

 

[Fluff]

Hi & welcome to MrExcel
How about
=SUMIFS(C$2:C$22,$A$2:$A$22,">=11",$A$2:$A$22,"<=22")

 

[confusedexcel4]

Thank you!!! That solved my problem

 

[Fluff]

You're welcome & thanks for the feedback.

 

[lauralechner]

How about if you wanted to sum the columns of D or column E depending on the heading of the column? I am attempting to summarize deposits by month (columns D & E), distribution center (column A) and account number (row 1) all on the Deposits tab. I can get the follow to work if I only pull from one column at a time and eliminate the account number/row 1 criteria:

SUMIFS(Deposits!$D$2:$E$5,Deposits!$A:$A,$D$14,Deposits!$D$1:$E$1,$O$1,Deposits!$C:$C,"<"&EDATE($B17,1),Deposits!$B:$B,">="&$B17)

	A	B	C	D	E
1				20063	20061
2	ATL	12/1/2018	12/31/2018	300
3	KCMO	1/1/2019	1/15/2019		550
4	SFO	1/16/2019	1/31/2019	200	100
5	STL	2/1/2019	2/15/2019		375

<tbody>
</tbody>

<tbody>
</tbody>

Thank you! Laura

<tbody>
</tbody>