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.

Thanks



"JE McGimpsey" wrote:

Perhaps I'm dense, but I'm not understanding here...

Do you want to count asterisks in each row, columns D & I, putting the
result in column X of that row?

Or do you want to count all the asterisks in columns D & I and put that
in some cell in column X? If so, how many rows should be looked at for
the value that goes into the cell in column Y (i.e., cells without
asterisks)?



In article ,
"anat" wrote:

Sorry I should have been more clear:

Col X should look at D and I and total the number of astericks. Col Y
should total the cells without astericks.