Excel Magic Trick 1388

Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)

DESCRIPTION

See how to calculate the Average Number of Days Between Order Date & Ship Date with three different methods:
(00:10) Introduction
(00:25) Helper Column Method & AVERAGE Function
(02:22) Array Formula #1: AVERAGE Function with Array Operation. This Requires the special keystrokes: Ctrl + Shift + Enter
(03:12) Learn how to Name Ranges (Defined Names) with Create Names From Selection feature
(08:36) Array Formula #2: SUMPRODUCT, Array Operation & COUNT function
(11:42) Summary

WORKBOOKS

Download “Excel Magic Trick 1388-1390” dq2hcjgi5zikp31zptoqb6mdyvjy3wcj.zip – Downloaded 38 times – 6 B







Be the first to comment

Leave a Reply