Does it matter if the name is very long? Why not just test for length
being greater than 1 (i.e. your first term)?

Pete

On Jan 29, 8:04*pm, John in Wembley wrote:
On Tue, 29 Jan 2008 14:49:43 -0500, "PCLIVE"

wrote:
Where is "guest" entered?

Let's say it is column B...then:
=SUMPRODUCT(--(LEN(A1:A10)=2),--(LEN(A1:A10)<=30),--(B1:B10<"guest"))

HTH,
Paul

thanks to both of you, Guest will be in place of the patients name...
You would not belive how long some names are! I started out with LEN
15 and as you see, currently up to 30.
Kiwi names are shorter!
"mate", "gidday mate" etc etc...