Help Converting Array to Application.Evaluate?

[sthrncaliguy]

Hello,

I have a worksheet that I am trying to count how many rows meet 3 criteria.

I think I can just do an array formula, and then insert it into VBA via Application.Evaluate, but I am struggling a bit with the syntax.

Here is what I am trying to match..

Criteria 1: Cell in Col D = a variable
Criteria 2: Cell in Col E = a variable
Criteria 3: Cell in Col AA = a variable

All 3 variables are Strings, and I want to count how many rows on the sheet match all 3 variables.

Ultimately this is part of a loop and says:

For each Cell in myRange
Cell.value = Application.Evaluate(....)
Next Cell

I need help with the (...) part, based on the above description.

Thank you in advance!