Reference
	Relative Reference
	Absolute Reference
	Mixed Reference

Jeans


COUNTIF(range,criteria)
SUMIF(range,criteria,[sum_range])
AVERAGEIF(range,criteria,[avg_range])

range - where we filter
criteria - what we filter
sum_range - where we calculate


COUNTIFS(r1,c1,r2,c2....)
SUMIFS(sum_range,r1,c1,r2,c2....)
AVERAGEIFS(avg_range,r1,c1,r2,c2....)


Medium Shirt


VERTICAL
VLOOKUP

HORIZONTAL
HLOOKUP



<5L   		 0.0%
5L to 7L	 2.0%
7L to 10L	 3.5%
>10L		 5.0%

565892


VLOOKUP(lookup_value, table_array, column_ind, range_lookup)

lookup_value - what we search
table_array - where we search
range_lookup - how we search

Approximate - 1 / TRUE
Exact Match - 0 / FALSE

Vertical
Lookup_Value
 - Unique
 - First Column
 - Ascending

----------------------------------------------------------------

INDEX
MATCH


Match(lookup_value, lookup_array, match_type)
Index(array, row, [column])

-----------------------------------------------------------------


2007, 2010, 2013, 2016, 2019, 2021
M365


LOOKUP
VLOOKUP
HLOOKUP
INDEX
MATCH

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [Match_mode], [search_mode])

__________________________________________________________________


if(logical_test,value_if_true,value_if_false)