All lessons
StatisticsintermediatePro

AVERAGEIF & MEDIAN

AVERAGEIF exercises: average only the rows that match a condition, find the true middle value of a list with MEDIAN, and sum with a wildcard pattern.

Read the full guide to AVERAGEIF and MEDIAN Practice →

AVERAGEIF & MEDIAN is a Pro lesson

Upgrade to Pro to unlock this lesson and every other lesson on Excel Practice Lab.

See Pro plans