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/
