faster way to do countif via vba for large dataset

Hi,

I am enclosing a test file which is just a small sample of the dataset I actually have to consider.

Since the data set I am working with is large I cant use the application.countif type function.........its just way tooooo slow.


using the enclosed file: what I am trying to calculate is the following:

if I were to use equations in excel they might look like the following:

=countif(
ColN, "Open",
ColF, "Site*",
ColG, H2,
ColX, <= I2,
ColO, > DefnNameTAT)

+

countif(
ColN, "Open",
ColF, "Site*",
ColG, H2,
ColX, =&"All",
ColO, > DefnNameTAT)


Note: DefnNameTAT is a user defnd name and its value is located in M1


I started the macro..........i thought using a scripting dictionary would be helpful.....


I have probably confused someone......if so let me know.


note: i had to keep deleting rows from my input file so that it would make the 1000kB file size requirment.........but i did not go back and update the last row values i put into the macro.