If the value you are checking for is "x" then try this

=COUNTIF(G$5:G$7,"x")=1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"lauraroebuck" wrote:


Hi

I have used the countA function in data validation in order that, from
a range of cells only one option can be slected using "x". If they try
to select more than one option an error meeasge is displayed. This works
fine, however I now need to use this same formula on a subsequent range
which contains empty string "". Obviously CountA counts this therefore
no option can be selected.

Is there a way for the formula to ignore ""?

The formula I have used in Data, Validation, Custom is:

=COUNTA(G$5:G$7)=1

Please help!

Many thanks

Laura;)


--
lauraroebuck
------------------------------------------------------------------------
lauraroebuck's Profile: http://www.thecodecage.com/forumz/member.php?userid=289
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122629