While I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions ...

First, argument y (the test) is very flexible ... clearer when you see how the function works in an example. This Excel table contains people's names, ages, genders, and salaries, and your ...