How many months am I covering in %?

[Romano_odK]

Good afternoon,
This little sheet should give me an advice on how many months I am covering with the value in V5. Now the months are listed from C to O. The Value in V5 is for this example covering 2 months. Those two months are 2 months of 8 months that have a value, so need to know how many % is covered. This is not easy I think and for me undoable. Can you help me please.
Thank you for your time

MRP voorraadbeheer met XML import 1.4.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1			refresh	12/01/2023 16:52		datum	12/01/2023
2	Directory:	C\:temp\100MRP.xml	01/2022	02/2022	03/2022	04/2022	05/2022	06/2022	07/2022	08/2022	09/2022	10/2022	11/2022	12/2022	01/2023
3	itemcode	description	q-12	q-11	q-10	q-9	q-8	q-7	q-6	q-5	q-4	q-3	q-2	q-1	q-0	Totaal	Average week	Average months	Highest	Delivery time	Extra stock weeks	Advice Min-max	Covering %
4	133000	Kunststof Rasterblok 6x2 mm blauw - 1000 stuks																		14	2	-
5	133001	Kunststof Rasterblok 6x2 mm blauw - 100 stuks	20	1	10	21	20			30	10	30				142	4,4	18	30	14	2	18
6	133002	Kunststof Rasterblok 6x3 mm rood - 1000 stuks																		14	2	-
MRP

Cell Formulas
Range	Formula
D1	D1	=NOW()
G1	G1	=(TODAY())
C2	C2	=EDATE(TODAY(),-12)
D2	D2	=EDATE(TODAY(),-11)
E2	E2	=EDATE(TODAY(),-10)
F2	F2	=EDATE(TODAY(),-9)
G2	G2	=EDATE(TODAY(),-8)
H2	H2	=EDATE(TODAY(),-7)
I2	I2	=EDATE(TODAY(),-6)
J2	J2	=EDATE(TODAY(),-5)
K2	K2	=EDATE(TODAY(),-4)
L2	L2	=EDATE(TODAY(),-3)
M2	M2	=EDATE(TODAY(),-2)
N2	N2	=EDATE(TODAY(),-1)
O2	O2	=EDATE(TODAY(),0)
P4:P6	P4	=SUM(C4:O4)
Q4:Q6	Q4	=IFERROR(AVERAGEIF(C4:O4,">0")/4,"")
R4:R6	R4	=IFERROR(AVERAGEIF(C4:O4,"<>0"),"")
S4:S6	S4	=MAX(Tabel_Query_van_G100[@[q-12]:[q-0]])
V4:V6	V4	=IFERROR(IFS(AA4="Klantorder","-",U4=0,(Q4*(T4/7)),U4>0,(Q4*U4)+(Q4*(T4/7))),"")