Office Expert

COUNTIF  & SUMIF

If we have a list of data and we need to find out total count & Sum with certain conditions ,then we can use functions "Countif" & "Sumif"

Syntax of Countif 

COUNTIF(range,criteria)

Example :-

Students with their attendance and Internal Marks .The student named jubin attends class once in a week & he is absent in rest of the days in a week and he got Internal mark "23".But Vinoy is a dedicated student and attend class everyday and got Internal mark "50".

Here we want to know how many students attend class everyday .

Answer we will get will be "2" .It means only two students are attending class everyday

Same way we can find howmany students are attending class once in a week 

The equation will be "=countif(B:B,"Once In a Week")"

SUMIF

Syntax

SUMIF(range,criteria,sum_range)

If we want to find out the sum of internal marks got by the students attending the class "everyday" & "Once in a week " ,then we can use the function sumif