This formula will sum all the even numbers from a given range of values. An even number is defined as any number that has a remainder of 0 when divided by 2.

This formula will return the position of the first non blank cell within a given range.

This formula will return a count of the number of cells in a given range which contain a formula.

This formula will return the position of the first blank cell within a given range.

This formula will return the relative position of the minimum value in a given range of numerical values. The formula will work for any one dimensional vertical or horizontal range. If the range contains multiple minimums, then the formula will return the position of the top most or left most minimum.

This formula will return the relative position of the maximum value in a given range of numerical values. The formula will work for any one dimensional vertical or horizontal range. If the range contains multiple maximums, then the formula will return the position of the top most or left most maximum.