Reducing Formula functions

  • Thread starter Thread starter mahadevan.swamy
  • Start date Start date
M

mahadevan.swamy

I have a workbook that is of 30 MB file size as there are millions of
cells that consists of heavy functioned formulas. This workbook
depends on another workbook (Book 3) and it takes lots of time to
open. My objective to reduce these formulas to one or two lines using
less amount of functions. Here are the formulas: -

=SUM(IF('[Book3.xls]Customer Returns (External)'!$A$3:$A$1200=$C$2,
IF('[Book3.xls]Customer Returns (External)'!$C$3:$C$1200=C$3,
IF('[Book3.xls]Customer Returns (External)'!$D$3:$D$1200=$A6,
IF(ISBLANK('[Book3.xls]Customer Returns (External)'!$J$3:$J$1200),
IF(ISBLANK('[Book3.xls]Customer Returns (External)'!$I$3:$I$1200),
'[Book3.xls]Customer Returns (External)'!$H$3:$H$1200,
'[Book3.xls]Customer Returns (External)'!$I$3:$I$1200),
'[Book3.xls]Customer Returns (External)'!$J$3:$J$1200)))))

Does anyone have a better formula for this? Thanks

Swamy
 
One thing is to create defined names in the DESTINATION workbook that refer
to the SOURCE wb such as
rnga
='[Book3.xls]Customer Returns (External)'!$A$3:$A$1200
 
Back
Top