VBE313
Well-known Member
- Joined
- Mar 22, 2019
- Messages
- 686
- Office Version
- 365
- Platform
- Windows
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 |