This formula will return the percent of the month completed for a given date.

#### How To Do A Case Sensitive Lookup

This formula will perform a **vertical case sensitive lookup** in a given range of values and return a result from the corresponding cell in another range. The functionality of this formula is similar to the **VLOOKUP** function, however VLOOKUP does not differentiate between upper and lower case letters when looking for a match. To VLOOKUP “**AAA**” and “**aaa**” would be the same thing.

#### How To Sum All Odd Numbers In A Range

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

#### How To Sum All Even Numbers In A Range

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 Count All Odd Numbers In A Range

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

#### How To Count All Even Numbers In A Range

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.

## Get The Latest News

### Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!