Need assist on SUMIF/S

[butcherrrr]

Good day. Can I get a little help in figuring this out? (Im such a noob with this and cannot get it to work).


This is a sample dataset where we get batches of some products with their costs and expiry. I would like to automate the raw data that I get and generate a report like this (sample below) of the cost of all BATCH C and a separate one for BATCH D that will be expiring in 'x' days.

I just need a little nudge on the syntax and how to generate it. I just dont know how to start. Thank you.

 

[Peter_SSs]

Welcome to the MrExcel board!

Are those decimal values under "EXPIRY" days? If not, where do we get the days figure from?

 

[butcherrrr]

Welcome to the MrExcel board!

Are those decimal values under "EXPIRY" days? If not, where do we get the days figure from?

Sorry I forgot to edit the days part. The days would be round numbers, no decimal points after them.

The days figure would be auto generated from the list we get from our system.

I made another sample dataset below:

APPROX COST	BATCH	TYPE	EXPIRY		BATCH TYPE
307,000.00	A	1	2465​
2,223,189.86	C	1	232​		Get the approx cost of all
22,916.89	C	1	0​		vegetables expiring in (x)
10,432.75	A	11	0​		days of only Batches C & D
9,158.33	A	2	0​
44,791.67	C	11	0​
9,579.17	A	11	0​		BATCH 1 -VEGETABLES
171,425.77	A	12	45​		1-360	1,348,738.07
624,000.00	C	1	0​		361-730
610,081.41	A	1	0​		731-1095
884,767.45	A	12	87​		1096-1460
87,512.29	A	16	0​		1460+	1,008,789.67
30,000.00	D	17	0​			2,357,527.74
5,500.00	A	19	0​
359,591.58	D	19	0​		BATCH 2 - FRUITS
28,160.80	A	2	43​		1-360	1,996,469.65
2,358.54	A	19	0​		361-730	240,615.29
84,292.38	D	19	0​		731-1095	1,116,651.40
54,233.16	A	1	0​		1096-1460	1,316,077.95
10,267.72	B	19	0​		1460+	3,432,455.26
54,115.73	A	2	5​			8,102,269.55
113,209.81	B	2	58​
8,730.86	A	19	0​
32,778.37	B	1	132​
59,171.24	A	19	2318​
25,547.51	A	1	22​

 

[Peter_SSs]

Sorry I forgot to edit the days part. The days would be round numbers, no decimal points after them.

Never-the-less, which are the days? No heading says days.