Thank you. The countblank function did not work for that. I need to count the number of companies with those three fields missing. My data is in a table.