I have had same problem with Countif. It isn't just impatience -- when
I first paste the formulas into a grid they calculate the first time in
about 15 seconds. But if they ever need to recalculate, it freezes, and
I've left it for quite awhile waiting.

To get these answers I ultimately had to paste the formulas to get the
answers initially, then set calculation to manual so it wouldn't try to
recalculate and freeze, then replace the cells with their values, then
re-set calculation to automatic. I had to do this repeatedly and would
be interested in what the problem/solution is.


--
fselker
------------------------------------------------------------------------
fselker's Profile: http://www.excelforum.com/member.php...o&userid=31655
View this thread: http://www.excelforum.com/showthread...hreadid=513397