For more then two criteria we use SUMIFS rather then SUMIF , because it can handle more then one argument to be summed against. The first argument this formula takes in the range to be summed and then it follow the criteria range and criteria till 217 conditions.
0
For more then two criteria we use SUMIFS rather then SUMIF , because it can handle more then one argument to be summed against. The first argument this formula takes in the range to be summed and then it follow the criteria range and criteria till 217 conditions.