I hve been fighting with this for the last week or so. I have a column which
has the potential to show 100 items. it is a basically filled in with a
statement that shows the cell as blank if there is nothing in it.

The issue I am having is that I want to count the amount of entries, but it
keeps counting all the cells with a formula in it.

Can I get help on how to make it so it ignores the cells with a formula

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1