I have a spreadsheet with lots of data running off formulas, all i want is a count formula that will count the enrys shown not the formulas, there are numbers and text on this sheet so it dosent matter what column it reads from, all i want it to do is give me the answer of 2 for example if there are 200 cells with 2 pieces of data shown.

Thanks in advance

DJ