"Manish Bajpai" wrote...
Please use sumproduct formula which will be :

=(sumproduct((Page1(rangeA="MC)*(rangeB))*2.20462 )
+(sumproduct((Page2(rangeA="MC)*(rangeB))*2.20462 )
+(sumproduct((Page3(rangeA="MC)*(rangeB))*2.20462 )
....

What the heck is Page1(..), Page2(..) and Page3(..)? Answer: syntactically,
Excel would treat them as function calls. Since they're not built-in
functions, Excel would attempt to resolve them as udfs. However, you failed
to include the necessary code for these udfs (or mention that they'd need to
be udfs), so your wonderful formula would return a #NAME? error.

Do you know what you're doing?