How to have a proper Count in Excel cellss

[want_to_learnexcel]

My problem is:

I am in Sheet "To Print"

Which Cell Formula Output
Cell A1 ='names'!D1 Daniel Day Lewis
Cell A2 ='names'!D2 Saiorse Ronan
Cell A3 ='names'!D3 William Neeson
Cell A4 ='names'!D4 Christian Bale
Cell A5 ='names'!D5 (empty output)

Although I'm the the "To Print" sheet, my formula's in Cell A1:A5, are all based on the input of "names" sheet.

When I count Cell A1:A5, it counts as 5. But in the output there are just 4 names. Cell A5 turned out empty (although it has a formula). How is it possible to count, that it should only be 4?

I used the formula:
=COUNTA(A1:A5)

The output is 5, but it should be 4.

[dogberry]

Hi

Ive tried to replicate your problem but I keep getting a correct result can you post a sample

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[Ghozi Alkatiri]

Try this

=COUNTIF(A1:A5;"<>0")