Formual for Sum

Delroy Bosco

New member
Joined
Jun 23, 2012
Messages
2
Reaction score
0
Points
0
Location
A, A
Hi All,

I've created a roster for about 30 employees. It is designed it for this month and has every employee's name on it. Every date is recorded with Either Present or Absent or Offs. However, I'm unable to come up with a formula as to count how many days was one particular employee present.

I've attached a screenshot for you guys to understand, if I'm confusing you.Excel.jpg
 
Hi Delroy Bosco...

you can use the COUNTIF() function for getting the number number of cells within a range
that meet a single criterion that you specify. Example =COUNTIF(C16:C32;"Present")

Regards :)
 
Hi Acolyte,

Thanks for your reply, I tried exactly as you wrote.

It worked !
 
yes the countif function can only be used when the condition is accomplished
 
Back
Top