Advanced Excel
  • Introduction to Excel
  • Security
  • Short Keys
  • Practice Data Sheets
  • Data Formats
  • Conditional Formatting
  • Format as Table
  • Data Sorting
  • Data Filtering
  • Remove Duplicates
  • Data Validation
  • Text-To-Columns
  • Data Consolidation
  • What-if-Analysis
  • Grouping
  • Absolute & Relative Referencing
  • Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
  • Task1 - Mathematical Formulas
  • Logical Functions - IF, IFERROR, AND, OR
  • Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
  • Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
  • Vlookup Formula
  • Task2 - Vlookup Problems
  • Vlookup with Match Formula - Dynamic Duo
  • Vlookup using (*) example
  • Vlookup with Running Countif
  • Task3 - Vlookup, Running Countif Problem
  • Lookup Functions - Hlookup, Index Match
  • Lookup Functions - Indirect, Offset
  • Vlookup-Indirect Example
  • Sumif, Indirect, Offset, Match Example
  • Array Functions
  • Task4 - Array Problem
  • Advanced Conditional Formatting using Formula
  • Data Validation using Indirect Function
  • Charts, Waterfall Graph
  • Pivot Table, Dashboards
Powered by GitBook
On this page

Was this helpful?

Sumif, Indirect, Offset, Match Example

Refer the Attached Sheet.

294KB
Sumif, Indirect, Offset, Match Example.xlsx
Indirect, Offset, Match Example

PreviousVlookup-Indirect ExampleNextArray Functions

Last updated 6 years ago

Was this helpful?