Forum Discussion

Anonymous

Mar 16, 2018

Solved

Counting a certain percentage reached as 1 for attendance

Hi all, I am trying to work on a database used for attendance calculations, essentially to avoid any double counting in data collection. If a person attends 3 days out of 5 then this should equ...

Formulas & Functions

Need Help

Matt Mickle
Mar 16, 2018
Try these two formulas:

=COUNTA(A2:E2)

=IF(F2>=3,1,0)

Matt Mickle

Bronze Contributor

Mar 16, 2018

Try these two formulas:

=COUNTA(A2:E2)

=IF(F2>=3,1,0)

Anonymous
Mar 16, 2018
it worked!!! -

Thank you very much for quick response!! Much appreciated!