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 amartak...@gmail.com wrote:
Hi All,
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com 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
If you Delete the rows mentioned.. then the formula you have mentioned works
On Fri, Jan 11, 2013 at 2:09 PM, amar takale amartak...@gmail.com wrote:
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:
Dear Amar,
You are getting a
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