COUNTIFS function
This function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...
Read MoreThis function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...
Read MoreThis function will rounds a number down to the nearest integer. Syntax INT(Number) Number (required) – This is the number you want to round down to the nearest integer. Example In this example find the round down a few...
Read MoreThis function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum....
Read MoreThis function will return the absolute value of a number. The absolute value is the “positive” part of a number. Syntax ABS(Number) Number (required) – This is the number you want to find the absolute value of....
Read More