Syntax:
=SUMIF(range, criteria, [sum_range])
Syntax Description:
range argument is used to give the range of cells in which criteria needs to find,
criteria argument is used to give criteria for sum. We can give value (example “A”,”A*” >10, 50 ) or cell reference# (example: E2) in this argument,
sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned above