Hello!
In this thread https://www.excelforum.com/excel-for...xcel-slow.html
saw "there is little to no benefit to be had by limiting the range passed to COUNTIF" and get interested
I checked up the above functions. The worst result is SUMPRODUCT, the rest functions seems to ignore blank cells.
If results are correct then user defined ranges are not so actual in some cases.
no index COUNIF
1 COUNTIFS
2 SUMPRODUCT
3 SUMIFS
Bookmarks