# How can I SUM this?

#### VBE313

##### Well-known Member
I have the following table below. I need to sum the Price if Ship Date is greater than the first of the year, AND less than today AND if Name is either Ethan, Jon, or Mike. How can I sum that? The only formula I could come up with can only extract one name.

VBA Code:
``=SUMIFS(Table1[Price],Table1[Ship Date],"<"&TODAY(),Table1[Ship Date],">"&DATE(YEAR(TODAY()),1,1),Table1[Name],"=Ethan")``

 Part Number Ship Date Name Price Part Number 123 12/20/2020 Ethan \$ 55.00 Part Number 456 12/21/2020 Jon \$ 110.00 Part Number 789 12/22/2020 Mike \$ 130.00 Part Number 1122 12/23/2020 Mike \$ 150.00 Part Number 1455 12/24/2020 Mike \$ 170.00 Part Number 1788 12/25/2020 Jon \$ 190.00 Part Number 2121 12/26/2020 Jon \$ 210.00 Part Number 2454 12/27/2020 Ethan \$ 230.00 Part Number 2787 12/28/2020 Emily \$ 250.00 Part Number 3120 12/29/2020 Emily \$ 270.00 Part Number 3453 12/30/2020 Emily \$ 290.00 Part Number 3786 12/31/2020 Jill \$ 310.00 Part Number 4119 1/1/2021 Emily \$ 330.00 Part Number 4452 1/2/2021 Emily \$ 350.00 Part Number 4785 1/3/2021 Mike \$ 370.00 Part Number 5118 1/4/2021 Mike \$ 390.00 Part Number 5451 1/5/2021 Jon \$ 410.00 Part Number 5784 1/6/2021 Emily \$ 430.00 Part Number 6117 1/7/2021 Jon \$ 450.00 Part Number 6450 1/8/2021 Ethan \$ 470.00 Part Number 6783 1/9/2021 Emily \$ 490.00 Part Number 7116 1/10/2021 Jon \$ 510.00 Part Number 7449 1/11/2021 Jon \$ 530.00 Part Number 7782 1/12/2021 Emily \$ 550.00 Part Number 8115 1/13/2021 Ethan \$ 570.00 Part Number 8448 1/14/2021 Ethan \$ 590.00 Part Number 8781 1/15/2021 Emily \$ 610.00 Part Number 9114 1/16/2021 Emily \$ 630.00 Part Number 9447 1/17/2021 Ethan \$ 650.00 Part Number 9780 1/18/2021 Ethan \$ 670.00 Part Number 10113 1/19/2021 Ethan \$ 690.00 Part Number 10446 1/20/2021 Emily \$ 710.00 Part Number 10779 1/21/2021 Emily \$ 730.00 Part Number 11112 1/22/2021 Jon \$ 750.00 Part Number 11445 1/23/2021 Emily \$ 770.00 Part Number 11778 1/24/2021 Jon \$ 790.00 Part Number 12111 1/25/2021 Jon \$ 810.00 Part Number 12444 1/26/2021 Jon \$ 830.00 Part Number 12777 1/27/2021 Jon \$ 850.00 Part Number 13110 1/28/2021 Emily \$ 870.00 Part Number 13443 1/29/2021 Jill \$ 890.00 Part Number 13776 1/30/2021 Jill \$ 910.00 Part Number 14109 1/31/2021 Emily \$ 930.00 Part Number 14442 2/1/2021 Emily \$ 950.00 Part Number 14775 2/2/2021 Mike \$ 970.00 Part Number 15108 2/3/2021 Mike \$ 990.00 Part Number 15441 2/4/2021 Mike \$ 1,010.00 Part Number 15774 2/5/2021 Emily \$ 1,030.00 Part Number 16107 2/6/2021 Emily \$ 1,050.00 Part Number 16440 2/7/2021 Emily \$ 1,070.00 Part Number 16773 2/8/2021 Emily \$ 1,090.00 Part Number 17106 2/9/2021 Emily \$ 1,110.00 Part Number 17439 2/10/2021 Emily \$ 1,130.00 Part Number 17772 2/11/2021 Emily \$ 1,150.00 Part Number 18105 2/12/2021 Emily \$ 1,170.00 Part Number 18438 2/13/2021 Emily \$ 1,190.00 Part Number 18771 2/14/2021 Mike \$ 1,210.00 Part Number 19104 2/15/2021 Jill \$ 1,230.00 Part Number 19437 2/16/2021 Emily \$ 1,250.00 Part Number 19770 2/17/2021 Emily \$ 1,270.00 Part Number 20103 2/18/2021 Ethan \$ 1,290.00 Part Number 20436 2/19/2021 Ethan \$ 1,310.00 Part Number 20769 2/20/2021 Ethan \$ 1,330.00 Part Number 21102 2/21/2021 Ethan \$ 1,350.00 Part Number 21435 2/22/2021 Ethan \$ 1,370.00 Part Number 21768 2/23/2021 Ethan \$ 1,390.00 Part Number 22101 2/24/2021 Emily \$ 1,410.00 Part Number 22434 2/25/2021 Emily \$ 1,430.00 Part Number 22767 2/26/2021 Emily \$ 1,450.00 Part Number 23100 2/27/2021 Emily \$ 1,470.00 Part Number 23433 2/28/2021 Jill \$ 1,490.00 Part Number 23766 3/1/2021 Jill \$ 1,510.00 Part Number 24099 3/2/2021 Jill \$ 1,530.00 Part Number 24432 3/3/2021 Jill \$ 1,550.00 Part Number 24765 3/4/2021 Emily \$ 1,570.00 Part Number 25098 3/5/2021 Emily \$ 1,590.00 Part Number 25431 3/6/2021 Mike \$ 1,610.00 Part Number 25764 3/7/2021 Emily \$ 1,630.00 Part Number 26097 3/8/2021 Emily \$ 1,650.00 Part Number 26430 3/9/2021 Emily \$ 1,670.00 Part Number 26763 3/10/2021 Emily \$ 1,690.00 Part Number 27096 3/11/2021 Emily \$ 1,710.00 Part Number 27429 3/12/2021 Emily \$ 1,730.00 Part Number 27762 3/13/2021 Emily \$ 1,750.00 Part Number 28095 3/14/2021 Emily \$ 1,770.00 Part Number 28428 3/15/2021 Emily \$ 1,790.00 Part Number 28761 3/16/2021 Emily \$ 1,810.00 Part Number 29094 3/17/2021 Emily \$ 1,830.00 Part Number 29427 3/18/2021 Emily \$ 1,850.00 Part Number 29760 3/19/2021 Emily \$ 1,870.00 Part Number 30093 3/20/2021 Mike \$ 1,890.00 Part Number 30426 3/21/2021 Emily \$ 1,910.00 Part Number 30759 3/22/2021 Emily \$ 1,930.00 Part Number 31092 3/23/2021 Emily \$ 1,950.00 Part Number 31425 3/24/2021 Emily \$ 1,970.00 Part Number 31758 3/25/2021 Emily \$ 1,990.00 Part Number 32091 3/26/2021 Mike \$ 2,010.00 Part Number 32424 3/27/2021 Emily \$ 2,030.00 Part Number 32757 3/28/2021 Emily \$ 2,050.00 Part Number 33090 3/29/2021 Emily \$ 2,070.00 Part Number 33423 3/30/2021 Emily \$ 2,090.00

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### VBE313

##### Well-known Member
Code:
``=SUM(SUMIFS(Table1[Price],Table1[Ship Date],"<"&TODAY(),Table1[Ship Date],">"&DATE(YEAR(TODAY()),1,1),Table1[Name],"="&{"Ethan","Mike","Jon"}))``

#### etaf

##### Well-known Member
=SUM(SUMIFS(Table1[Price],Table1[Ship Date],"<"&TODAY(),Table1[Ship Date],">"&DATE(YEAR(TODAY()),1,1),Table1[Name],"{"Ethan","Jon","Mike"}))

Replies
6
Views
692
Replies
1
Views
92
Replies
0
Views
78
Replies
0
Views
314
Replies
5
Views
120

1,181,606
Messages
5,930,858
Members
436,764
Latest member

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