View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sum Based on Exception

.. I havent worked with xl07 yet, i bet that is what I am thinking about

Neither have I. Btw, a little bird also told me that in xl07, the sheet's
extended to 1 million rows. Given this phenomenal increase (from 65k) I
wonder how the resultant recalc speeds look like if there were extensive
sumproduct/array-entered conditional sum expressions with entire col refs
used liberally. Any comments from those using xl07?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---