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.

#### How To Find The Position Of The First Non Blank Cell In A Range

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

#### How To Count The Number Of Formulas In A Range

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

#### How To Find The Position Of The First Blank Cell In A Range

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

#### How To Find The Position Of The Minimum

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.

#### How To Find The Position Of The Maximum

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.