# Sumifs with range

#### confusedexcel4

##### New Member
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>

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hi & welcome to MrExcel
=SUMIFS(C\$2:C\$22,\$A\$2:\$A\$22,">=11",\$A\$2:\$A\$22,"<=22")

Thank you!!! That solved my problem

You're welcome & thanks for the feedback.

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>

Replies
6
Views
743
Replies
6
Views
1K
Replies
7
Views
795
Replies
0
Views
294
Replies
9
Views
838

1,221,185
Messages
6,158,407
Members
451,490
Latest member
desktopace

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back