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
 

maninweb

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
2010, 2016, 2016 Insider
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 :)
 

Delroy Bosco

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

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

It worked !
 

Rishi Gupta

New member
Joined
Jul 20, 2012
Messages
7
Reaction score
0
Points
0
yes the countif function can only be used when the condition is accomplished
 
Top