Macro. Number of rows in column that meet 2 criteria in other 2 columns. Use of "CountIfs"

[lcgar]

Hi everyone!,

Iīm doing an excel macro and need to calculate the number of cells in a column that meet 2 criteria in 2 other. In other words, letīs take that I want to calculate the number of rows in column "D" that meet that, in the same row but in column A, you have "blabla" and in column B you have a number lower than another priorly calculated number.

Iīm trying to implement all this using the countifs function in VBA, as follows:
The problem is that it returns an error and donīt know why. is it that the function is not well written, or is it that something else could have been wrong? (variable not declared, my excel version doesnīt support the countifs function, etc...)


Ironically, the countif function works perfectly with just one criteria. Does anyone know what is it happening? if itīs not possible to proceed this way? would it be possible that you give me a good and quick alternative?


Thanks a lot in advance for your kind responses.

[lcgar]

Application.CountIf works, but Application.CountIfs doesn't:

I can't post the whole function I use, because the site blocks it.

Thank you!

[JeteMc]

Not a VBA person, so can't help you there. If the argument includes a less than operator (<) then put a space behind it when posting.
Let us know if you have any questions.