Can you assume that if there is nothing in the OPENED MAIL column that it was not opened?
Assuming Col F is where you want to see the "UNOPENED" and Col E contains the email addresses, then
a formula in Column F could say something like:
=IF(E4<>"","","UNOPENED")