Something like this, in say C2:
=sumproduct((A$2:A$100="Name1")*(B$2:B$100="Presen t"))
will return the required count of employee "Name1"'s attendance record - ie
where s/he was marked as "Present" in col B. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"cmsinsides" wrote:
I want to use Countif with 2 conditions. For example,
1. It searches for the Emp Name, I need - Emp Name column A
2. It checks whether the Emp is Absent / present - Emp Attendance column B
then counts the no. of appearances of this Emp name in Column A

The absentee can be manually deleted & then countif is to be applied but I
want a function to do this without deleting