sumproduct indirect
 

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:I4 99="S")*(RECORD!J3:J499="AED")*
(RECORD!K3:K499))+SUMPRODUCT((RECORD!A3:A499=TODAY ())*(RECORD!O3:O499="S")*
(RECORD!P3:P499="AED")*(RECORD!Q3:Q499))+SUMPRODUC T((RECORD!A3:A499=TODAY())*
(RECORD!T3:T499="S")*(RECORD!U3:U499="AED")*(RECOR D!V3:V499))
+SUMPRODUCT((RECORD!A3:A499=TODAY())*(RECORD!Y3:Y4 99="S")*(RECORD!Z3:Z499="AED")*
(RECORD!AA3:AA499))+SUMPRODUCT((RECORD!A3:A499=TOD AY())*(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

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=39359