Hi,

Suppose I have attendance timing in one sheet employee wise & I want summary of who are late comers that is after 10 am.

Using sumproduct am getting that, but employee Ids are not the same sorting as in sheet1.

Which formula would be useful.