Solved: Works with Array but the computer stay very slow

[Ismael]

Hi to all in the forum,

I hope that everything is ok with you guys.

So today, my doubt is about one array formula, the formula is on the column p on the file attach.
The formula works ok, and does exactly what I pretend, my problem is that my original board is 50 column x 1000 rows and when a drop down the formula the computer stay "stuck".

So if any of you guys can give me a help with another formula (without using the array) that doesn't slow the computer I really appreciate.

Kind regards,

Ismael

[mvidas]

Ismael,

You should be able to use:
=COUNTIF(B5:K5,">="&M5)-COUNTIF(B5:K5,">="&N5)

You could also use a sumproduct formula:
=SUMPRODUCT((B5:K5>=M5)*(B5:K5<N5))

Matt

[Ismael]

Hi Mat,

I test the formula that you give me and they works ok. Once that calculation is made row by row, the computer respond more faster now.


Thanks a lot. :beerchug:

regards,


Ismael