maybe i need a prof.formula for complex sump...
 

good day,

i have the 2 calculator formula to sumproduct the 6 different ranges...
(1)[{=SUM(QTY_ALL*Pi/index_base*Index_New_ALL/Index_ER)}]
(1.1)[=SUMPRODUCT(QTY_ALL*Pi/index_base*Index_New_ALL/Index_ER)]

(2)[{=SUM(QTY_ALL*Pi/Base_rate)}]
(2.1)[=SUMPRODUCT(QTY_ALL*Pi/Base_rate)]

this works so quick yet the named ranges are quite huge to check at their
contents...
my scenario is i need a little more touch on the formula to assure the
*expected* result....

the named ranges have the following dimension.

QTY_ALL : 27 rows X 17 columns...
Pi : 27 rows X 1 column
Base_rate : one cell
Index_base : 27 rows X 1 column...
Index_New_ALL : 27 rows X 17 columns...
Index_ER : 1 row X 17 columns...

my need is to assure that
there are no cell to be read as-in containing "text" or "",
if there is, then the sumproduct result show "REVIEW this &range."
i had some bug experience in this sheet where sometime, if i hit F2 in a
cell with formulas,then the formula becomes a text...really dont know
why...so ill just rely on the formula to detect any strange changes in the
sheet...

thanks for help...

--
regards,
driller

*****
- dive with Jonathan Seagull