sumproduct indirect

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: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 th
reduction.


with regards
nowfa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top