Count (But not formulas)

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

Not the perfect solution, however, in a spare cell put the formula:-

=COUNTIF(Range,">0"), where range is the cells with numbers/formulas.

Highlight your range and select Edit | Replace - In the Find what, enter an = sign, in the Replace with, enter a 0, then hit Replace All. All formulas start with an = sign, when these are replaced with a 0 the cells become text, if a cell has an = sign followed by a number, the cell will just remain the same (it won't put a leading zero in and the cells without = signs will stay as they are.

Check the cell with your Countif formula in, to give you the number of cells with values. When your finished, select the undo button to reverse your last procedure and put all your formulas back.

G

=SUMPRODUCT(--(range<>""))