https://bugs.documentfoundation.org/show_bug.cgi?id=144017
--- Comment #3 from Eike Rathke <er...@redhat.com> --- (In reply to John Murrell from comment #2) > However COUNTIFS does not actually work in my application, I think because > the list of random numbers re-calculates each time COUNTIFS runs so the > results keep on changing. RAND() and RANDBETWEEN() generate new random numbers on each cell input and whenever any recalculation occurs. You could use RAND.NV() or RANDBETWEEN.NV() for non-volatile random numbers. -- You are receiving this mail because: You are on the CC list for the bug.