Microsoft Excel 2013 - Combining the SUMIFS and INDIRECT functions

  Рет қаралды 29,974

Optimum

Optimum

Күн бұрын

This video demonstrates using Microsoft Excel’s SUMIFS function to total up a range of cells across multiple worksheets based multiple criteria ranges / criteria and adds a further level of complexity by nesting Excel’s INDIRECT function and concatenation.
This video was created by Optimum - the IT Training Consultancy.
For more information on our Microsoft Office training courses provided in central London, UK - please click here: www.optimum.co....

Пікірлер: 5
INDIRECT Function in Excel - Powerful Range References
11:35
TeachExcel
Рет қаралды 47 М.
小路飞嫁祸姐姐搞破坏 #路飞#海贼王
00:45
路飞与唐舞桐
Рет қаралды 27 МЛН
Ozoda - Lada ( Official Music Video 2024 )
06:07
Ozoda
Рет қаралды 22 МЛН
iPhone or Chocolate??
00:16
Hungry FAM
Рет қаралды 52 МЛН
Life hack 😂 Watermelon magic box! #shorts by Leisi Crazy
00:17
Leisi Crazy
Рет қаралды 73 МЛН
Excel Tests in Interviews: INDIRECT, MATCH, SUMIFS, and More
14:56
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 48 М.
How to SUM Dynamic Ranges in Excel with SUMIF and INDIRECT!
6:11
Anser's Excel Academy
Рет қаралды 1,4 М.
Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
10:54
Excel: INDEX and MATCH
10:47
Technology for Teachers and Students
Рет қаралды 207 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 327 М.
What are these ROW/COLUMN functions doing in my Excel formulas?
15:33
MyOnlineTrainingHub
Рет қаралды 30 М.
小路飞嫁祸姐姐搞破坏 #路飞#海贼王
00:45
路飞与唐舞桐
Рет қаралды 27 МЛН