Excel Xp's question

  • Thread starter Thread starter Candy Tong
  • Start date Start date
C

Candy Tong

Dear all,

Do you know why when i would like to count a num of column
in B and set the formula count(B7:B45), it appears green
flat at the right bottom corner. When mouse over the
corner, a warning msg with something about "adjacent cell"
error is prompt!

Do any one know why and how to solve it? Actually i have
tried to open the same file in excel2k's version, but not
problem occure...Pls help! Thanks
 
You're seeing Excel 2002's background error checking feature. It is
controlled by Tools, Options, Error Checking.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula omits adjacent cells 2
conditional formatting on formua with another cell 2
Average formula multiple worksheets 1
Vlookup for 3 sheets 6
tool: options disabled 1
Conditional format won't copy 7
Excel: Copying A Formula 3
SUM 3

Back
Top