What your mouth otherwise you will find yourself fished hooked like McGloin.

did it exactly,,,watch that grammar boy

I sussed it myself and done it exactly the way you said Ian.

To count the Emptys I done

=COUNTIF(D$5: D$17,"Empty")

To count the dates I used

=COUNT(D5: D17)

[Edited on 01-05-2007 by Rachel H]

If they're actually empty, use COUNTBLANK()

If they're the word 'Empty', use

=COUNTIF(A1:A13,"Empty")

Then use 13 minus that cell to tell you the opposite.

[Edited on 01-05-2007 by Ian]

my examples were in simple psuedo code, made perfect sense

That works but only returns a 0, the fact that the range has a forumla already in it that cannot be removed doesn't seem to effect it either.

=countif(A1:A13,"<>""")

A1:A13 is the collum of dates

<>"" will only work if the cell is blank will need to be changed if you have the cell set to display empty etc.

Doesn't make sense Steve?

if cellnumber <> ""

and

if cellnumber = ""

?

Got 13 columms across and 13 rows down with a series of dates in and if there aren't any dates in the cells then it shows Empty.

Now I have a total columm at the end and I need to know how many how many cells per row have dates in and how many have Empty in.

How would I go about this?