COUNTA ----- FORMULA WILL NOT COUNT NON BLANK CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when entering
=COUNTA(C9:C78) into a cell to count the non blank cells the formula is
displayed instead of the count.

Any suggestions as to how to resolve the problem would be appreciated
 
Hi

Sounds like the cell was preformatted as Text.
Format the cell as General, edit the formula with F2>press Enter
 
Or if you only see formulas, make sure you're not looking at formulas:

Tools|Options|view tab|uncheck formulas
(xl2003's menu)
 

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

Counting cells containing formulas with blank results 3
Why doesn't excel count function update automatically? 1
how to count non blank cells from another worksheet 1
COUNTA - ADDING CELLS 5
CountA question 2
sum to recognize new rows 3
Counting cells by font color 2
Using COUNTA and excluding formulas that gives zero or blank cells 3

Back
Top