EXCEL FUNCTION – ROWS
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
EXCEL FUNCTION – ROW
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,
EXCEL FUNCTION – INDIRECT
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
EXCEL FUNCTION – SUMIFS
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
EXCEL FUNCTION – COUNTIFS
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
EXCEL FUNCTION – SUMIF
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
EXCEL FUNCTION – INDEX
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
EXCEL FUNCTION – COLUMNS
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
EXCEL FUNCTION – COLUMN
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
EXCEL FUNCTION – TRIM
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
