SUMIF(range,criteria[,actual_range])
SUMIF function sums the values in the given @range that meet the given @criteria. If @actual_range is given, SUMIF sums the values in the @actual_range whose corresponding components in @range meet the given @criteria.
COUNTIF , SUM