Re: Please help - COUNTIF yields '#VALUE!" in Cells of 2nd sheet

[Rana Aich <ra...@yahoo.com>]

Hello All,

Is there any unresolved issue with setting CellFormula
with COUNTIF? I noticed the same issue in the
Jakarta-Poi mailing archive.

My Problem is:

When I use COUNTIF for seting the CellFormula I'm
getting '#VALUE!". I only get the values after
selecting the cell and pressing 'Enter' key.

Whereas, simple Formulas such as SUM and AVERAGE is
working fine.

Can anyone suggest a solution?





--- Rana Aich <ra...@yahoo.com> wrote:

> Thanks for your tips. Actually I went further and
> found that the Formula that I'm using has COUNTIF.
> The
> formula that gives me wrong result is as follows:
> 
>
=COUNTIF(sheet1!E2:E183,"<=499")-COUNTIF(sheet1!E2:E183,"<200")
> 
> Whereas, I've tried a simple formula as below:
> =SUM(sheet1!E2:E115) and Bingo! It is working. So it
> seems I have done something wrong with the String
> processing with "COUNTIF".
> 
> My "Calculation Tab" in "Tool>Option" is in
> Automatic
> mode.
> 
> --- deshmol-lists@yahoo.com wrote:
> 
> > Check whether you have 
> > 
> >  Tools > Options > [calculations_tab] >
> Calculation 
> > 
> > ...set to "Automatic".
> > 
> > 
> > Alternatively, you can also use
> > F9/Shift+F9/Ctrl+Alt+F9/Ctrl+Alt+Shift+F9 to
> > evaluate
> > all changed formulae in the sheet (look up the
> excel
> > help for details/differences of each key
> > combination.
> > 
> > 
> > ~ amol
> > 
> > --- Rana Aich <ra...@yahoo.com> wrote:
> > 
> > > Hi,
> > > 
> > > I'm generating an Excel File with two sheets :
> > > Sheet1
> > > and Sheet2. In Sheet1 I've calculated few
> formulas
> > -
> > > and they are working fine.
> > > 
> > > In the Sheet2 I put formulas based on values on
> > > Sheet1. But instead of getting the Proper Values
> > I'm
> > > getting "#VALUE!" in all the cells. Interstingly
> > > after
> > > clicking the individual cells in Sheet2 and
> > pressing
> > > the "Enter" key, the Cell value is shown.
> > > 
> > > How can I obtain the proper values in the cells
> of
> > > 2nd
> > > sheet instead of "#VALUE!"?
> > > 
> > > Thanking you all in advance.
> > > 
> > > 
> > > 
> > > 
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > poi-user-unsubscribe@jakarta.apache.org
> > > Mailing List:    
> > > http://jakarta.apache.org/site/mail2.html#poi
> > > The Apache Jakarta Poi Project: 
> > > http://jakarta.apache.org/poi/
> > > 
> > > 
> > 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > poi-user-unsubscribe@jakarta.apache.org
> > Mailing List:    
> > http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: 
> > http://jakarta.apache.org/poi/
> > 
> > 
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> poi-user-unsubscribe@jakarta.apache.org
> Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/