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 July 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.

Math (3)

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

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

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

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

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