I have a table that contains data
And id like to know the total sum of each month every year by inputing the year
Which formula can i use to get the values of each month when i put in the year there?
POSv2.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Invoice Number | Date | Qty | Item Description | Unit Price | Total | ||
2 | x | |||||||
3 | JAN210002 | 1/4/2021 | 2 | 6 inches round 3 flavours ,SUGAR SHEET | 200 | 400 | ||
4 | JAN210002 | 1/4/2021 | 4 | 6 inches round 3 flavours ,SUGAR SHEET | 200 | 800 | ||
5 | JAN210002 | 1/4/2021 | 1 | 6 INCHES ROUND 3 FLAVOURS CUSTOM(FLOWER) | 220 | 200 | ||
6 | JAN210003 | 1/4/2021 | 1 | 6 inches round - 3 flavours hidden image effect | 220 | 220 | ||
7 | JAN210003 | 1/4/2021 | 1 | 6 INCHES ROUND 3 FLAVOURS CUSTOM(FLOWER) | 220 | 220 | ||
8 | JAN210004 | 1/4/2021 | 1 | 6 inches round - 3 Flavors (More Toppings) | 200 | 200 | ||
9 | JAN210001 | 1/4/2021 | 1 | 6 inches round 3 flavours ,SUGAR SHEET | 200 | 200 | ||
10 | JAN210001 | 1/4/2021 | 1 | 6 inches round - 3 Flavors (More Toppings) | 200 | 200 | ||
11 | JAN210001 | 1/4/2021 | 2 | 6 inches round - 4 Flavors | 250 | 500 | ||
12 | JAN2100002 | 1/4/2021 | 1 | 6 inches round - 3 flavours hidden image effect | 220 | 220 | ||
13 | JAN2100003 | 1/4/2021 | 5 | 6 inches round 3 flavours ,SUGAR SHEET | 200 | 500 | ||
14 | JAN2100004 | 1/4/2021 | 1 | 6 inches round - 3 Flavors (More Toppings) | 200 | 195 | ||
15 | JAN2100004 | 1/4/2021 | 50 | Meat turnovers (Big) | 5 | 238 | ||
16 | JAN2100004 | 1/4/2021 | 1 | Sausage rolls (Small) 12 pieces) | 20 | 20 | ||
17 | JAN2100004 | 1/4/2021 | 2 | Fried chips (Olonka) | 50 | 95 | ||
18 | JAN2100005 | 1/5/2021 | 1 | 6 Inch Whipped Cream Cake [Rd] | 200 | 200 | ||
19 | JAN2100005 | 1/5/2021 | 1 | Breakfast Basket Medium [6 Heads] | 450 | 400 | ||
20 | JAN2100005 | 1/5/2021 | 20 | Mini Beef Burger | 7 | 140 | ||
21 | JAN2100005 | 1/5/2021 | 10 | Chicken Lollipop | 10 | 100 | ||
22 | JAN2100006 | 1/5/2021 | 1 | 7 Inch Whipped Cream Cake [Rd] | 250 | 250 | ||
23 | JAN2100006 | 1/5/2021 | 10 | Cornish Pie | 5 | 50 | ||
24 | JAN2100006 | 1/5/2021 | 1 | Lunch Basket Platinum [10-12 Heads] | 1000 | 950 | ||
Invoice Data |
And id like to know the total sum of each month every year by inputing the year
POSv2.xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
5 | Year | 2021 | |||
6 | |||||
7 | Date | Revenue | |||
8 | January | ||||
9 | February | ||||
10 | March | ||||
11 | April | ||||
12 | May | ||||
13 | June | ||||
14 | July | ||||
15 | August | ||||
16 | September | ||||
17 | October | ||||
18 | November | ||||
19 | December | ||||
Sheet2 |
Which formula can i use to get the values of each month when i put in the year there?