View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default DCOUNT Performance

"Paul Dennis" wrote...
....
I have a total of 230 DCOUNTA's and all using the same filter names, and
each DCOUNTA has 10 columns of 'and' filters and between 2 to 7 rows of
'or' filters.

....

If there were a fair amount of redundancy, row to row, in your criteria
range, there could be some performance gains. Impossible to be more precise
without seeing what the full criteria range looks like.