excel - I need to COUNT the number of times "LOI-" occurs in a range if the date in a neighboring column for that row falls within a specified range

Question

I have a spreadsheet where I need to COUNT the number of times "LOI-" occur in a range if the date in a neighboring column for that row falls within a specified range. I also want to save the new sum as a variable. This is what I am trying:

NumACXV = Application.CountIfs(.Range("P2:W" & last), _
                  .Range("P2:W" & last), "* LOI- *", _
                  .Range("K2:K" & last), ">12/31/2013", _
                  .Range("K2:K" & last), "<8/1/2015")

Answer 1

Unlike the SumIfs formula whos syntax is Range 1, Range 2, Range 2 Criteria

CountIfs seems to be using Range 1, Range 1 Criteria, Range 2, Range 2 Criteria

the working code is : NumACXV = Application.CountIfs(.Range("P2:P" & last), "<>", .Range("P2:P" & last), "*LOI-*", .Range("K2:K" & last), ">12/31/2013", .Range("K2:K" & last), "<8/1/2015")