Populate Mark Formula with airSlate SignNow

Populate mark formula

[Music] [Applause] [Music] please subscribe my channel like and share and click the bell icon for further updates and more informative video now let's dive in tell you one more interesting thing regarding attendance nowadays online classes are taking place uh regularly because of the pandemics so if you are taking attendance on excel it will be really good sometimes teachers are taking attendance on word microsoft word so it is not worthy for attendance microsoft word it is not made for that use excel only so i have written the attendance of the students here and i have written the name just to save time so first i'll try uh calculate the total how many days are there in total so 1 2 3 4 5 6 7 8 9 10 11 12 13 14. so total is 14 so i can write in the bracket the total days are 14. now i want to calculate the attendance if you want to calculate what will you do you will count the present here or you will either count the absent here and then subtract it and write here it will take a long time if you have imagine if you have 40 student in total different sections different classes so what if you use a formula and calculate for you by itself so i'm telling you the formula first you'll press equal to then you will click here to apply the formula you can click here also if you want to apply the formula but if you are applying formula click here because it's a formula bar and you have more space here so you will write a c-o-u-n-d count and if countif when you write the count you can see here it's a fourth option so you can click on this also or you can manually write also so if i double click you see the function appears automatically but i'll show you how if you are writing c o u n t i f countif and then they are asking you for the range so i am selecting all the range for the first student from starting to the end and then i'll press comma and then they are asking the criteria what is the criteria on which you want to mark the attendance so uh on the present so i i would put pen uh inverted commas and write p here i've told you whenever you you are denoting a text in excel you need to write it in inverted commas and then i'll close this and just press enter and you see the total attendance appeared here he has one absent here this is one absent only so total is 13. now you will just drag and drop all the way and done you see all the attendance is mark automatically you need not to count one by one so it's very easy and quick process now if you want to for example for certain...