Supplier List Excel Sheet Template

Key Features : S.No.Supplier IDSupplier NameContact PersonPhoneEmailCategoryCityGSTINPayment TermsCredit LimitStatusNotes / Remarks Formulas: S.No.=ROW()-4SUPPLIERS=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)