An ever-growing Excel Functions

My way of explaining each entry with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.

Last updated August 2026

Experience

I'll include all my experiences (good and bad) working with them.

For everyone

I want people to use it and share it. So I won't put any restriction on it on this reference.

By everyone

Please contribute! The better I can make it, the better it will be for everyone.

Lots of places

I learn from lots of places, so some things may be found elsewhere.

Logical (2)

Averages the values that meet one condition. Returns #DIV/0! when nothing qualifies.

Returns one of two values based on whether a condition is true or false.

Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.

Counts the cells in a range that meet one condition. Text matching ignores case.

Adds numbers, cells, or ranges into a single total. A single error in the range takes over the result.

Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.

Sums the values that meet several conditions at once. All conditions combine with AND, not OR.

Extracts characters from the middle of a text string, starting at a position you choose. Always returns text.