Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
|
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?
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
if cellnumber <> ""
and
if cellnumber = ""
?
|
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
|
Doesn't make sense Steve?
|
blebo
Member
Registered: 18th Apr 02
User status: Offline
|
=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.
|
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
|
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.
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
my examples were in simple psuedo code, made perfect sense
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
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]
|
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
|
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]
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
did it exactly,,,watch that grammar boy
|
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
|
What your mouth otherwise you will find yourself fished hooked like McGloin.
|
