Somehow, I missed your post. Your solution works well. Much easier than what
I was trying to do with the format.

Thanks,
~ Horatio

"Gromit" wrote in message
...

Hi,

Will this do?

=COUNTIF(attendance!B2:E2,"X") &"/"& (4-COUNT(attendance!B2:E2))


--
Gromit
------------------------------------------------------------------------
Gromit's Profile:
http://www.excelforum.com/member.php...nfo&userid=928
View this thread: http://www.excelforum.com/showthread...hreadid=319992