Excel Arrays for Unique Count in Rows

Total watch time

52m 48s

at 1× speed · exactly 52 minutes, 48 seconds at 1×

custom

1×	52m 48s
1.25×	42m 14s
1.5×	35m 12s
1.75×	30m 10s
2×	26m 24s

Average video17m 36s

Longest23m 6s

Shortest13m 53s

Compare Open on YouTube JSON

Plan to finish

About 1 day at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 1 day. Turn on JavaScript to plan around your week.

Videos (3)

52m 48s in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


1	How to Count Rows with OR condition with Excel Array Formula - SUMPRODUCT & FREQUENCY (Part 1/3)	23:06	2017-01-17
2	How to Use the Excel MMULT Function for Matrix Operations	13:53	2017-01-23
3	Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)	15:49	2017-02-01

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 52m 48s · 3 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs)

HTML

<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs.svg" alt="Watch time: 52m 48s · 3 videos" width="202" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLmHVyfmcRKyxsnv_kvZ7X_h7y7dTEzyGs returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.