Hi,

Fir text responses try

=COUNTA(A1:D1)1

or numeric

=COUNT(A1:D1)1

Mike

"BethO" wrote:

I would like to allow only 1 response in one of four cells. What formula
would I use to check if other cells are null?