Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT and INDIRECT | Excel Worksheet Functions | |||
sumproduct with indirect | Excel Worksheet Functions | |||
Need help with using SUMPRODUCT with INDIRECT | Excel Worksheet Functions | |||
Help with Sumproduct with Indirect | Excel Worksheet Functions | |||
sumproduct & indirect | Excel Worksheet Functions |