![]() ![]() SUMIF looks for cells in test_range that are equal to condition, unless condition is a text string that starts with a comparator: If sum_range is omitted the cells in test_range are summed.Ī number, such as 34.5 an expression, such as 2/3 or SQRT(B5) a text string SUMIF(test_range condition sum_range) This function identifies those cells in the range test_range that meet the condition, and sums the corresponding cells in the range sum_range. Conditionally sums the contents of cells in a range.
0 Comments
Leave a Reply. |