Calculating Average Price, Based on Multiple Cells

[greatscott1]

Hi All,

I wonder if anyone could help with one of the formulas I'm trying to create? Once I understand the one, I'll be able to adapt for the others I'm trying to do.

I have a separate sheet ("Statistics") where I specify a 'from' ('Statistics'!B3) and 'to' ('Statistics'!B4) date. I'd like to have a formula that will give me an average price paid for PRODUCT A across all suppliers, by multiplying column F by column J for all instances that fall between the date ranges specified (column A).

Many thanks in advance!

Timber CallOffs (WIP).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2						VOLUMES (m³)				RATES (£/m³)
3	Invoice Date	Invoice Number	PO Number (TFM/*****)	Ordered By	Supplier	PRODUCT A	PRODUCT B	PRODUCT C	PRODUCT D	PRODUCT A	PRODUCT B	PRODUCT C	PRODUCT D
4	02/12/2022	121231	11372	Employee 1	Supplier 3	29.244	19.447			£295	£15
5	06/12/2022	61002212	11379	Employee 1	Supplier 1	34.178	14.133			£295	£15
6	06/12/2022	61002213	11379	Employee 1	Supplier 1				1.512				£736
7	07/12/2022	121265	11380	Employee 1	Supplier 3	33.511	14.418			£295	£15
8	08/12/2022	334093	11374	Employee 1	Supplier 4	33.563	5.774		2.474	£295	£15		£700
9	12/12/2022	334121	11384	Employee 1	Supplier 4	44.991				£295
10	14/12/2022	121461	11386	Employee 1	Supplier 3	30.403	6.772	10.686		£295	£15	£220
11	16/12/2022	61002716	11389	Employee 1	Supplier 1	31.442	23.569			£295	£15
12	16/12/2022	121535	11387	Employee 1	Supplier 3	46.181		6.171		£295		£220
13	16/12/2022	121566	11392	Employee 1	Supplier 3	27.615	5.124	12.342		£295	£15	£220
14
15
Timber Invoices

 

[Skybluekid]

Glad that both myself and @etaf have helped