How To Use Probability Function With Multiple Crieterias?

[xlmaniac]

Dear All,

I do have an original data-set pertaining to Region-SKU wise supply, spanning more than 20,000 rows.

Following is the sample data-set for the month of March 2023 against 2 SKUs.

Based on data points, I would like to predict –(a)Probability of getting supply of the Region-SKU combinations in the next Purchase Order (b) % Supply Fill Rate Probability against the Region-SKU combinations.

Could this be done with PROB Function with multiple criteria?

I am using Office 2010.

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Region	# Instances	SKU No	Purchase Order No	Purchase Order Qty	Supplied Qty	% Supply Fill Rate		Region	SKU	Probability Of Getting Next Supply	Supply Fill Rate % Probability
2	East	1	131056	95001564	260	110	42%		East	131056
3	East	2	131056	95001697	180	0	0%		North	140752
4	East	3	131056	95001857	125	78	62%
5	East	4	131056	95014653	320	214	67%
6	East	5	131056	95017984	560	0	0%
7	East	6	131056	95021919	390	210	54%
8	North	1	140752	96512234	950	800	84%
9	North	2	140752	96513307	500	300	60%
10	North	3	140752	96516879	680	0	0%
11	North	4	140752	96517785	435	285	66%
12	North	5	140752	96518840	235	0	0%
Sheet1

Cell Formulas
Range	Formula
G2:G12	G2	=F2/E2