edit the formula in cells D163 and below and add =IFERROR(AX8/V8,0) . add
If error in all to avoid value errors
Or try this
=SUM(IF(ISNUMBER($C$163:$C$182+$D$163:$D$182),$C$163:$C$182*$D$163:$D$182,0))/C183
with Ctrl+shift+ Enter
or
Visit this link
http://www.mrexcel.com/forum/excel-questions/2
If you Delete the rows mentioned.. then the formula you have mentioned works
On Fri, Jan 11, 2013 at 2:09 PM, amar takale wrote:
> No problem hide row delete,no matter.
>
>
> On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote:
>
>> Dear Amar,
>>
>> You are getting a #Value error.. since you have
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote:
> Dear Amar,
>
> You are getting a #Value error.. since you have the following #Value
> errors in your data.
>
>
> ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN
> PHARMA ADVANCED RES
Dear Amar,
You are getting a #Value error.. since you have the following #Value errors
in your data.
ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN
PHARMA ADVANCED RESEARCH 33 #VALUE!
On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote:
> Hi All,
> Pls suggest me Sumpro
