is it possible to translate the following code in vba while using Application.WorksheetFunction.

=COUNT(IF(H:H=T36, IF(H:H<=T37, COUNTIF(D:D, "NAME"))))

Thanks in advance