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!

[TABLE="width: 196"]
<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>[TR]
[TD="width: 21, bgcolor: transparent"]A[/TD]
[TD="width: 41, bgcolor: transparent"]B[/TD]
[TD="width: 46, bgcolor: transparent"]C[/TD]
[TD="width: 45, bgcolor: transparent"]D[/TD]
[TD="width: 107, bgcolor: transparent"]E[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]A files[/TD]
[TD="bgcolor: transparent"]B files[/TD]
[TD="bgcolor: transparent"]Completed files[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"]Tues[/TD]
[TD="bgcolor: transparent, align: right"]266[/TD]
[TD="bgcolor: transparent, align: right"]290[/TD]
[TD="bgcolor: transparent, align: right"]176[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"]Wed[/TD]
[TD="bgcolor: transparent, align: right"]232[/TD]
[TD="bgcolor: transparent, align: right"]261[/TD]
[TD="bgcolor: transparent, align: right"]170[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"]Thurs[/TD]
[TD="bgcolor: transparent, align: right"]249[/TD]
[TD="bgcolor: transparent, align: right"]281[/TD]
[TD="bgcolor: transparent, align: right"]167[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"]Fri[/TD]
[TD="bgcolor: transparent, align: right"]124[/TD]
[TD="bgcolor: transparent, align: right"]145[/TD]
[TD="bgcolor: transparent, align: right"]133[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8[/TD]
[TD="bgcolor: transparent"]Mon[/TD]
[TD="bgcolor: transparent, align: right"]160[/TD]
[TD="bgcolor: transparent, align: right"]201[/TD]
[TD="bgcolor: transparent, align: right"]145[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent"]Tues[/TD]
[TD="bgcolor: transparent, align: right"]295[/TD]
[TD="bgcolor: transparent, align: right"]313[/TD]
[TD="bgcolor: transparent, align: right"]246[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent"]Wed[/TD]
[TD="bgcolor: transparent, align: right"]254[/TD]
[TD="bgcolor: transparent, align: right"]268[/TD]
[TD="bgcolor: transparent, align: right"]187[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11[/TD]
[TD="bgcolor: transparent"]Thurs[/TD]
[TD="bgcolor: transparent, align: right"]119[/TD]
[TD="bgcolor: transparent, align: right"]155[/TD]
[TD="bgcolor: transparent, align: right"]178[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent"]Fri[/TD]
[TD="bgcolor: transparent, align: right"]236[/TD]
[TD="bgcolor: transparent, align: right"]253[/TD]
[TD="bgcolor: transparent, align: right"]149[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent"]Tues[/TD]
[TD="bgcolor: transparent, align: right"]280[/TD]
[TD="bgcolor: transparent, align: right"]296[/TD]
[TD="bgcolor: transparent, align: right"]166[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]17[/TD]
[TD="bgcolor: transparent"]Wed[/TD]
[TD="bgcolor: transparent, align: right"]287[/TD]
[TD="bgcolor: transparent, align: right"]306[/TD]
[TD="bgcolor: transparent, align: right"]179[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]18[/TD]
[TD="bgcolor: transparent"]Thurs[/TD]
[TD="bgcolor: transparent, align: right"]283[/TD]
[TD="bgcolor: transparent, align: right"]308[/TD]
[TD="bgcolor: transparent, align: right"]214[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]19[/TD]
[TD="bgcolor: transparent"]Fri[/TD]
[TD="bgcolor: transparent, align: right"]205[/TD]
[TD="bgcolor: transparent, align: right"]228[/TD]
[TD="bgcolor: transparent, align: right"]197[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]22[/TD]
[TD="bgcolor: transparent"]Mon[/TD]
[TD="bgcolor: transparent, align: right"]198[/TD]
[TD="bgcolor: transparent, align: right"]230[/TD]
[TD="bgcolor: transparent, align: right"]231[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]23[/TD]
[TD="bgcolor: transparent"]Tues[/TD]
[TD="bgcolor: transparent, align: right"]333[/TD]
[TD="bgcolor: transparent, align: right"]344[/TD]
[TD="bgcolor: transparent, align: right"]237[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]24[/TD]
[TD="bgcolor: transparent"]Wed[/TD]
[TD="bgcolor: transparent, align: right"]344[/TD]
[TD="bgcolor: transparent, align: right"]352[/TD]
[TD="bgcolor: transparent, align: right"]216[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]25[/TD]
[TD="bgcolor: transparent"]Thurs[/TD]
[TD="bgcolor: transparent, align: right"]264[/TD]
[TD="bgcolor: transparent, align: right"]278[/TD]
[TD="bgcolor: transparent, align: right"]242[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]26[/TD]
[TD="bgcolor: transparent"]Fri[/TD]
[TD="bgcolor: transparent, align: right"]262[/TD]
[TD="bgcolor: transparent, align: right"]271[/TD]
[TD="bgcolor: transparent, align: right"]277[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]29[/TD]
[TD="bgcolor: transparent"]Mon[/TD]
[TD="bgcolor: transparent, align: right"]273[/TD]
[TD="bgcolor: transparent, align: right"]284[/TD]
[TD="bgcolor: transparent, align: right"]207[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent"]Tues[/TD]
[TD="bgcolor: transparent, align: right"]371[/TD]
[TD="bgcolor: transparent, align: right"]377[/TD]
[TD="bgcolor: transparent, align: right"]191[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]31[/TD]
[TD="bgcolor: transparent"]Wed[/TD]
[TD="bgcolor: transparent, align: right"]130[/TD]
[TD="bgcolor: transparent, align: right"]143[/TD]
[TD="bgcolor: transparent, align: right"]221[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20063[/TD]
[TD]20061[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ATL[/TD]
[TD]12/1/2018[/TD]
[TD]12/31/2018[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]KCMO[/TD]
[TD]1/1/2019[/TD]
[TD]1/15/2019[/TD]
[TD][/TD]
[TD]550[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]SFO[/TD]
[TD]1/16/2019[/TD]
[TD]1/31/2019[/TD]
[TD]200[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]STL[/TD]
[TD]2/1/2019[/TD]
[TD]2/15/2019[/TD]
[TD][/TD]
[TD]375[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 392"]
<tbody>[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you! Laura[TABLE="width: 328"]
<tbody>[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]