# Video Lesson: Math and Statistical Functions

This Excel video lesson is about the Experience Level 1 Math and Statistical Functions in Excel.  Here is the level 1 function list extract from the Master Workbook that goes along with the video lesson.

The formulas discussed in the video are as follows:

MIN – MAX – AVERAGE – MEDIAN – SUM – PRODUCT – SUMPRODUCT

COUNT – COUNTA – COUNTBLANK – ABS – COUNTIF – COUNTIFS

SUMIF – SUMIFS – AVERAGEIF – RAND – RANDBETWEEN

ROUND – ROUNDDOWN – ROUNDUP – SUBTOTAL

EDIT: The Gross Profit formula should not be including the ‘Retail Price’ in it’s SUM function.  I’ve left this mistake in there so that the numbers remain the same in the video & file, but I just wanted to point out that the calculation is incorrect.

Next up if you’re following the Lesson Guide is learning about Date & Time Functions (e.g. TODAY, MONTH)

## 6 thoughts on “Video Lesson: Math and Statistical Functions”

1. This video isn’t loading in this screen or on Vimeo. The other videos are? Any ideas why

• Hey Cam,

The video loads fine for me. What kind of computer (PC/Mac) and what browser are you using?

Might be a temporary hiccup which will correct itself, or may be related to something else.

Cheers,

Ben

2. Howdy Ben,

When I opened the spreadsheet to the section you’re on, I noticed that in the average category – Cell number C 118 – it read 15.50 and in the median category – Cell number C119 it read 15 instead of what you have with to start with in the video.

Sincerely

Colby