Hi ,
I am not sure that using VBA will change anything.
From what I can see, your SUMIFS formulae are in only 4 columns , U , V , Y and AA.
In column Y , I don't see why the SUMIFS calculation should happen if there is no data in the column X.
Similarly , in column AA , I don't see why the SUMIFS calculation should happen if there is no data in the column Z.
These two column formulae can therefore be rewritten as :
Column Y : =IF(X5 = "", 0, SUMIFS($X$5:$X$6880,$N$5:$N$6880,N5,$D$5:$D$6880,D5,$B$5:$B$6880,1))
Column AA : =IF(Z5 = "", 0, SUMIFS($Z$5:$Z$6880,$N$5:$N$6880,N5,$D$5:$D$6880,D5,$B$5:$B$6880,1))
In column U , instead of having an additional IF condition test , I tried using this formula :
=SUMIFS($T$5:$T$6880,$N$5:$N$6880,N5,$D$5:$D$6880,D5, $B$5:$B$6880,1)
From what I can see , most of the data relates to individual parties in Pune ; where there are groups involved , the data is very little compared to the overall data size , say 50 rows in 7000.
Going by this , can you not separate the data into 2 worksheets , one containing data only for individual parties in Pune , and the other for groups ?
This way each worksheet will have to deal with a lesser amount of data.
Narayan
