In this video I am going to teach you how to use countif() function in Microsoft excel. You will learn how to combines the if function and count function. This combination lets you to count the number of times specific data is found in a range of cells. You can find total present in attendance sheet. The if portion of the function concludes what data meets the identified criteria and the count part does the counting.
