Hello -

I currently have a function that counts the blanks in a column and if the
column is blank, "* Required" disappears:
=IF((COUNTBLANK(E13:E16)=4),"", "* Required!")

The character filling the cells in the column is an asterisk, when the cell
to the left of that column is empty.

This is like your normal web app that has required fields.

Problem: I don't want to hard code the function. I would much rather write
one that uses something like " 0". The logic would be, if the count of the
asterisks in the range is 0 then display the "* Required" else, display
nothing. I don't know what function to use to do this. I tried CountIF and
CountA but I couldn't get them to work.

Any help will be greatly appreciated!


--
Sandy