Key Features :
S.No.
Supplier ID
Supplier Name
Contact Person
Phone
Email
Category
City
GSTIN
Payment Terms
Credit Limit
Status
Notes / Remarks
Formulas:
S.No.
=ROW()-4
SUPPLIERS
=COUNTIF($G$5:$G$1000,F18)
Total Suppliers =COUNTA(C5:C1000)
Active Suppliers =COUNTIF(L5:L1000,”Active”)
On Hold Suppliers =COUNTIF(L5:L1000,”On Hold”)
Inactive Suppliers =COUNTIF(L5:L1000,”Inactive”)
Total Credit Limit =SUM(K5:K1000)
Average Credit Limit =IFERROR(AVERAGE(K5:K1000),0)
Total Suppliers
=COUNTA(‘Supplier List’!C5:C1000)
Active Suppliers
=COUNTIF(‘Supplier List’!L5:L1000,”Active”)
On Hold Suppliers
=COUNTIF(‘Supplier List’!L5:L1000,”On Hold”)
Inactive Suppliers
=COUNTIF(‘Supplier List’!L5:L1000,”Inactive”)
Total Credit Limit
=SUM(‘Supplier List’!K5:K1000)
Average Credit Limit
=IFERROR(AVERAGE(‘Supplier List’!K5:K1000),0)
