uswyne
Board Regular
- Joined
- Jul 27, 2017
- Messages
- 78
- Office Version
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD]Required Answer[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]My Answer[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Formula Used[/TD]
[TD]=(countif(A1:A10,"Late Coming)/3)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
3 late coming = 1
i need to round down with countif formula or anyother way.
plz suggest
<tbody>[TR]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Late Coming[/TD]
[/TR]
[TR]
[TD]Required Answer[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]My Answer[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Formula Used[/TD]
[TD]=(countif(A1:A10,"Late Coming)/3)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
3 late coming = 1
i need to round down with countif formula or anyother way.
plz suggest
Last edited: