Converting Countifs formula to VBA

[Mohammed Waseem]

Dear Reader,

How I can write VBA program - I am beginner.

I had created an excel sheet with two sheets "Sheet 1 for filling reporting the data" "Sheet 2 for counting the filled or reported data".

I had used following formula - =COUNTIFS('EHS Walk & Talk Report Status'!B2:B1000,"W1",'EHS Walk & Talk Report Status'!C2:C1000,"Oct",'EHS Walk & Talk Report Status'!D2:D1000,"FY17-18",'EHS Walk & Talk Report Status'!M2:M1000,"B # 25",'EHS Walk & Talk Report Status'!O2:O1000,"Outstanding")

Criteria range will remains the same but criteria will change like following

Weeks	Months	Fiscal Year	Budget Units	Remarks	condition
W1	Oct	FY 17-18	B # 25	Outstanding	Unsafe Act
W2	Nov		B # 50	Rectified	Unsafe Condition
W3	Dec		B # 51 & 81		Rectified
W4	Jan		B # 52		Outstandings
W5	Feb		B # 52-HGPR		Good Practice
	Mar		B # 60
	Apr		B # 61
	May		MFS- Tool Depot
	Jun		B # 72
	Jul		B # 73
	Aug		B # 75
	Sep		B # 76
			B # 77
			B # 79
			B # 80
			B # 90
			B # 92
			Al Majal
			All Dept
			PS CD

<tbody>
</tbody><colgroup><col span="2"><col><col><col><col></colgroup>

 

[Joe4]

Welcome to the Board!

You can use COUNTIFS in VBA, you just call it like this:

Application.WorksheetFunction.Countifs(...)