N
nowfal
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
fear it is become so huge and it may slowing down the other procedure
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
499="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 th
reduction.
with regards
nowfa
The below sumproduct formula have a problem while deleting the rows
the number is reducing . so i would like to put indirect formula,but
fear it is become so huge and it may slowing down the other procedure
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
499="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 th
reduction.
with regards
nowfa