Foaie Colectiva De Prezenta Excel Online

=COUNTIF(D2:AG2,"P") For absences:

| A | B | C | D | E | F | ... | |---|---|---|---|---|---|---| | | Nume | Prenume | Data 1 | Data 2 | Data 3 | ... (continue for each day of the month) | foaie colectiva de prezenta excel

=COUNTIF(D2:AG2,"A") To count both "P" and "CS" as present: =COUNTIF(D2:AG2,"P") For absences: | A | B |