USING COUNTIF IN VBA

[Zayn_21]

HI ,

I inserted countif to calculate the count according to two criteria . but however I was thinking if it is possible to do it vba. someone please guide me (:

formula inserted in each cell of column B:E
=COUNTIFS(Sheet1!D:D,"B",Sheet1!E:E,"AIM1")

[patel]

count=WorksheetFunction.CountIf(Worksheets(1).Rang e("D:D"), "B")