Getting only non-blank cell when checking for a crtieria
Used Functions
Category: Logical
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)
Practice IFERROR Formula at Sheetzoom
IFERROR formula at Microsoft helpCategory: Lookup and reference
Uses an index to choose a value from a reference or array
Syntax
INDEX(array, row_num, [column_num])
Category: Statistical
Returns the k-th smallest value in a data set
Syntax
SMALL(array, k)
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Category: Lookup and reference
Returns a reference offset from a given reference
Syntax
OFFSET(reference, rows, cols, [height], [width])
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
Category: Lookup and reference
Returns a reference as text to a single cell in a worksheet
Syntax
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Category: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
0
This formula looks for the match of month and type, return the match, and the corresponding 8 rows downward. Then it looks if it has "y" in it and gives corresponding row number and this filtered using small function