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 <[EMAIL PROTECTED]> 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. > > --- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: > > > [EMAIL PROTECTED] > > > Mailing List: > > > http://jakarta.apache.org/site/mail2.html#poi > > > The Apache Jakarta Poi Project: > > > http://jakarta.apache.org/poi/ > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > Mailing List: > > http://jakarta.apache.org/site/mail2.html#poi > > The Apache Jakarta Poi Project: > > http://jakarta.apache.org/poi/ > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > Mailing List: > http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: > http://jakarta.apache.org/poi/ > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
