Hi - Looking for performance enhancement advise.

Hi - I am using DCOUNTA to calculate both a total and a pass in a
calculation to workout percentage passed, based on several filters in a sheet
of data which is 20,000 records.

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.

I have a look up that changes one of the filter values in all DCOUNTA's and
when I make the selection it takes 1min 34sec to recalculate.

Is this normal and expected or is there a better method or syntax ?

Typical DCOUNTA is =DCOUNTA('Incident Data'!$A:$Z,1,A5:K9).

one filter field has =IF(FixFilter_Name="","",FixFilter_Value) and there are
a total of 330 of these.


Any ideas on how to reduce the calculation time?