Hi,
The below sumproduct formula have a problem while deleting the rows, the number is reducing . so i would like to put indirect formula,but i fear it is become so huge and it may slowing down the other procedures like while running macro . Is there any better solution for this.
=SUMPRODUCT((RECORD!A3:A499=TODAY())*(RECORD!I3:I499="S")*(RECORD!J3:J499="AED")*
(RECORD!K3:K499))+SUMPRODUCT((RECORD!A3:A499=TODAY())*(RECORD!O3:O499="S")*
(RECORD!P3:P499="AED")*(RECORD!Q3:Q499))+SUMPRODUCT((RECORD!A3:A499=TODAY())*
(RECORD!T3:T499="S")*(RECORD!U3:U499="AED")*(RECORD!V3:V499))
+SUMPRODUCT((RECORD!A3:A499=TODAY())*(RECORD!Y3:Y499="S")*(RECORD!Z3:Z499="AED")*
(RECORD!AA3:AA499))+SUMPRODUCT((RECORD!A3:A499=TODAY())*(RECORD!AD3:AD499="S")*
(RECORD!AE3:AE499="AED")*(RECORD!!AF3:AF499))

total 5 sets of coloumns are there. Actually it was the number 500, when i deleted one raw it reduced to 499. I wanted to avoid the reduction.


with regards
nowfal