How to find Count If functions

[Anonymous]

Hi. 

I want to find the total number of Y from the mentioned column and then assign a weightage score to this. how can i do this?

	Please fill details here (fill NA if not applicable)	Mandatory (Y/N)
Name of the Startup	ABC	Y
Certificate of Incorporation of Company (Date)	13th August, 2019	Y
Memorandum of Association (Date)	30th August, 2019	Y
Articles of Association (Date)	30th August, 2019	Y
Trade License (Date)	23rd April, 2019	Y
Filing of Audited Balance Sheet (Date)	Financial Statements not audited	Y
Filing of Shareholding Pattern (Date)	7th January, 2019	Y
Share Certificate Issuance (Date)	No	Y
AGM Report (Date)	No	Y
Tax Filing TDS (Date)	No	Y
Excise Duty Tax Filing (Date)	No	Y
Count of shareholders with valid NID (age proof+address proof). (share the documents for each)	3
Count of shareholders with valid TIN number (share documents of all shareholders)	4
TIN certificate of the company
VAT certificate of the company

[VahidDM]

Hi @Anonymous 

Sorry, I couldn't get your request very well, can you add more details bout the result?

Appreciate your Kudos!!