Sum the values from the column for a specific period which matches values from another column corresponding to that specific period

[thetnaingsoe]

Hi everyone

I have a few columns (column A to H) representing "PO number" and "PO line item" with the date range being Billing Period.
Column I has the resource names.
There are some other columns at the back (column J to W) which represents "Hours" and "Cost" with the date range.

I am making a summary for each billing period along with PO Number, PO line item and its corresponding cost.

I was trying to write a sumproduct formula to achieve the result in summary, but it was giving me #NA.

Is there any other formula which can produce the same result in summary?

 

[awoohaw]

@thetnaingsoe
Please post your data as a minisheet or table. To paste as a mini sheet install the xl2bb add in (link below).
Also, please post expected values.

 

[thetnaingsoe]

@awoohaw
Here is the minisheet. And the cost in summary table is the expected values.

Excel Questions.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Jan-23	Jan-23	Feb-23	Feb-23	Mar-23	Mar-23	May-23	May-23		Jan-23	Jan-23	Feb-23	Feb-23	Mar-23	Mar-23	Apr-23	Apr-23	May-23	May-23	Jun-23	Jun-23	Jul-23	Jul-23
2	Jan-23	Jan-23	Feb-23	Feb-23	Apr-23	Apr-23	Jul-23	Jul-23		Jan-23	Jan-23	Feb-23	Feb-23	Mar-23	Mar-23	Apr-23	Apr-23	May-23	May-23	Jun-23	Jun-23	Jul-23	Jul-23
3
4	Pre-Acquisition	Pre-Acquisition	Pre-Acquisition	Pre-Acquisition	Pre-Acquisition	Pre-Acquisition	Post-Acquisition	Post-Acquisition	Resources	Jan-23	Jan-23	Feb-23	Feb-23	Mar-23	Mar-23	Apr-23	Apr-23	May-23	May-23	Jun-23	Jun-23	Jul-23	Jul-23
5	PO Number	PO Line Item	PO Number	PO Line Item	PO Number	PO Line Item	PO Number	PO Line Item		Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
6	111	All	222	3	444	1	666	1 & 2	A	2	200	1	100	0	0	1	100	2	200	5	500	1	100
7	222	2	111	All	555	1	777	1	B	1	200	1	200	1	200	1	200	1	200	2	400	1	200
8	333	5	333	4	333	2	888	1	C	1	150	2	300	2	300	1	150	3	450	3	450	1	150
9
10	Summary
11	Billing Period	PO Number	PO Line Item	Cost
12	Jan-23	111	All	200
13	Jan-23	222	2	200
14	Jan-23	333	5	150
15	Jan-23	333	4	0
16
17	Feb-23	222	3	100
18	Feb-23	111	All	200
19	Feb-23	333	5	0
20	Feb-23	333	4	300
21
22	Mar-23	333	3	0
23	Mar-23	444	1	0
24	Mar-23	555	1	200
25	Mar-23	333	2	300
26
27	Apr-23	444	1	100
28	Apr-23	555	1	200
29	Apr-23	333	2	150
Sheet1

Cell Formulas
Range	Formula
D12:D14	D12	=K6
D17:D18	D17	=M6
D20	D20	=M8
D23:D25	D23	=O6
D27:D29	D27	=Q6