Категории

2-10: Use AutoSum to sum a non-contiguous (non adjacent) range

Опубликовано: 09 Апрель 2026
на канале: The Smart Method
7,184
19

In this video lesson you'll learn how to Use Excel's AutoSum feature to sum a non-contiguous range (a block of cells that are not next to each other). You'll see how to use AutoSum to automatically place a total (SUM function) anywhere on the worksheet.

This video comes from the "Doing Useful Work with Excel" session (Session 2 in our YouTube Excel Essential Skills free video training course).

You'll find the lessons in this session easier with our free e-book: https://thesmartmethod.com/Excel-free...

play_arrow
15,327
66

ww2 Коп по войне 28.11.15, неплохо.

ww2 Коп по войне 28.11.15, неплохо.
play_arrow
2,279
87

First Diwali after selection as a teacher 🥰I have succeeded, now it is your turn!! Motivation video

First Diwali after selection as a teacher 🥰I have succeeded, now it is your turn!! Motivation video
play_arrow
33
0

SnowRunner | Morrison's Landslide | Pedro Bay Alaska, USA

SnowRunner | Morrison's Landslide | Pedro Bay Alaska, USA
play_arrow
10,738
122

Pandora Box 4-Player Upgrade: Connecting Additional Controllers

Pandora Box 4-Player Upgrade: Connecting Additional Controllers
play_arrow
390
2

Chapter 4 Foundation & Stress Distribution in Soil

Chapter 4 Foundation & Stress Distribution in Soil
play_arrow
10,624
122

Installer RetroArch et ses 30 systems sur WiiU

Installer RetroArch et ses 30 systems sur WiiU
play_arrow
1,104
0

Конец эфира (REN-TV, май 2001)

Конец эфира (REN-TV, май 2001)
play_arrow
281
17

Всем исполнения мечт!!! У меня минус одна)))

Всем исполнения мечт!!! У меня минус одна)))
Похожие видео
play_arrow
Excel Essential Skills Course - Session 2: Doing Useful Work with Excel

Excel Essential Skills Course - Session 2: Doing Useful Work with Excel
play_arrow
2-1: Enter and Edit Text and Numbers in an Excel Worksheet

2-1: Enter and Edit Text and Numbers in an Excel Worksheet
play_arrow
2-2: Open and view two Excel workbooks at the same time

2-2: Open and view two Excel workbooks at the same time
play_arrow
2-3: Use AutoSum to quickly calculate totals

2-3: Use AutoSum to quickly calculate totals
play_arrow
2-4: Select a range of cells and understand Smart Tags

2-4: Select a range of cells and understand Smart Tags
play_arrow
2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter

2-5: Speed Data Entry: Enter, Tab, Shift+Tab, Shift+Enter & Ctrl+Enter
play_arrow
2-6: How To Select Multiple Excel Rows and Columns

2-6: How To Select Multiple Excel Rows and Columns
play_arrow
2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges

2-7: Select Non-Contiguous (Non-Adjacent) Cell Ranges
play_arrow
2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.

2-8: Keyboard Shortcuts to Select an Range Of Cells within a Block.
play_arrow
2-9: Automatically Re-size Multiple Excel Rows and Columns

2-9: Automatically Re-size Multiple Excel Rows and Columns
play_arrow
2-10: Use AutoSum to sum a non-contiguous (non adjacent) range

2-10: Use AutoSum to sum a non-contiguous (non adjacent) range
play_arrow
2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.

2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.