One way:

X1: =(D1="*")+(I1="*")
Y1: =2-X1

Select X1 and Y1 and copy down as far as necessary.

In article ,
"anat" wrote:

Yes, I want to count the number of asterisks in each row (of columns D & I)
and put the result in column X of that row. And if it has no asterisks count
the blanks and put the results in Col Y since the asterisks represents a type
of an employee.