how to execute a formula copied into an excel cell

G

Guest

Hi,

in cell(Q9) i have used a formula ->"= COUNTA($C$17:$C$47)"
now in the range c17 to c47 i am writing string values though I keep some
cells in between blank. I want the cell(q9) to display the total number of
cells having data. But it displays "0" always. I need to select the cell and
hit and enter/return to get the correct answer. Whts this problem, can u plz
hlp me?

regards,
kaustav
 

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

Add on to formula 4
Help with formula 1
Time Sum in Excel 1
Formula Help 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
formula to enter data into a blank cell 1
Blank cell with average formula 1
Conditional formatting to test blank text cell 4

Top