SUM
★☆☆Returns the sum of selected values or ranges.
SUM(number1, [number2], ...)
Categoria: Agregacion
Funciones de Excel Referencia
97 funciones principales. Alterna entre detalle y practica para consolidar aprendizaje.
SUMIF
★☆☆Sums values that meet a condition.
SUMIF(range, criteria, [sum_range])
Categoria: Agregacion
SUMIFS
★★☆Sums values that meet multiple conditions.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Categoria: Agregacion
SUBTOTAL
★★☆Returns a subtotal with specified aggregate function.
SUBTOTAL(function_num, ref1, [ref2], ...)
Categoria: Agregacion
AGGREGATE
★★★Performs aggregate calculations with ignore options.
AGGREGATE(function_num, options, array, [k])
Categoria: Agregacion
AVERAGE
★☆☆Returns the arithmetic mean.
AVERAGE(number1, [number2], ...)
Categoria: Agregacion
AVERAGEIF
★★☆Returns average for values matching a condition.
AVERAGEIF(range, criteria, [average_range])
Categoria: Agregacion
AVERAGEIFS
★★☆Returns average for values matching multiple conditions.
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Categoria: Agregacion
COUNT
★☆☆Counts cells that contain numbers.
COUNT(value1, [value2], ...)
Categoria: Agregacion
COUNTA
★☆☆Counts non-empty cells.
COUNTA(value1, [value2], ...)
Categoria: Agregacion
COUNTBLANK
★☆☆Counts blank cells in a range.
COUNTBLANK(range)
Categoria: Agregacion
COUNTIF
★☆☆Counts cells matching a condition.
COUNTIF(range, criteria)
Categoria: Agregacion
COUNTIFS
★★☆Counts cells matching multiple conditions.
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Categoria: Agregacion
MAX
★☆☆Returns the largest value.
MAX(number1, [number2], ...)
Categoria: Agregacion
MIN
★☆☆Returns the smallest value.
MIN(number1, [number2], ...)
Categoria: Agregacion
LARGE
★★☆Returns the k-th largest value in an array.
LARGE(array, k)
Categoria: Agregacion
SMALL
★★☆Returns the k-th smallest value in an array.
SMALL(array, k)
Categoria: Agregacion
RANK.EQ
★★☆Returns the rank of a number in a list.
RANK.EQ(number, ref, [order])
Categoria: Agregacion
IF
★☆☆Basic conditional branching function.
IF(logical_test, value_if_true, value_if_false)
Categoria: Condicional
IFS
★★☆Evaluates multiple conditions in order.
IFS(logical_test1, value_if_true1, ...)
Categoria: Condicional
IFERROR
★★☆Returns fallback value when formula errors.
IFERROR(value, value_if_error)
Categoria: Condicional
IFNA
★★☆Returns fallback value for #N/A errors.
IFNA(value, value_if_na)
Categoria: Condicional
AND
★☆☆Returns TRUE when all conditions are TRUE.
AND(logical1, [logical2], ...)
Categoria: Logica
OR
★☆☆Returns TRUE when any condition is TRUE.
OR(logical1, [logical2], ...)
Categoria: Logica
NOT
★☆☆Reverses a logical value.
NOT(logical)
Categoria: Logica
SWITCH
★★☆Matches expression to values and returns mapped result.
SWITCH(expression, value1, result1, [default])
Categoria: Condicional
CHOOSE
★★☆Returns a value from a list by index.
CHOOSE(index_num, value1, [value2], ...)
Categoria: Condicional
VLOOKUP
★☆☆Looks up a value in the first column and returns matching value.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Categoria: Busqueda
HLOOKUP
★★☆Looks up a value in first row and returns matching value.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Categoria: Busqueda
XLOOKUP
★★☆Modern lookup function with flexible matching.
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
Categoria: Busqueda
LOOKUP
★★☆Performs vector lookup in sorted data.
LOOKUP(lookup_value, lookup_vector, [result_vector])
Categoria: Busqueda
INDEX
★★☆Returns value from array by row/column position.
INDEX(array, row_num, [column_num])
Categoria: Busqueda
MATCH
★★☆Returns relative position of lookup value in a range.
MATCH(lookup_value, lookup_array, [match_type])
Categoria: Busqueda
XMATCH
★★★Enhanced MATCH with additional matching/search options.
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Categoria: Busqueda
OFFSET
★★★Returns reference offset from a starting reference.
OFFSET(reference, rows, cols, [height], [width])
Categoria: Busqueda
INDIRECT
★★★Converts text to a cell reference.
INDIRECT(ref_text, [a1])
Categoria: Busqueda
ROW
★☆☆Returns row number of a reference.
ROW([reference])
Categoria: Busqueda
ROWS
★☆☆Returns number of rows in an array.
ROWS(array)
Categoria: Busqueda
COLUMN
★☆☆Returns column number of a reference.
COLUMN([reference])
Categoria: Busqueda
COLUMNS
★☆☆Returns number of columns in an array.
COLUMNS(array)
Categoria: Busqueda
LEFT
★☆☆Returns leftmost characters from text.
LEFT(text, [num_chars])
Categoria: Texto
RIGHT
★☆☆Returns rightmost characters from text.
RIGHT(text, [num_chars])
Categoria: Texto
MID
★☆☆Returns characters from middle of text.
MID(text, start_num, num_chars)
Categoria: Texto
LEN
★☆☆Returns the number of characters in text.
LEN(text)
Categoria: Texto
FIND
★★☆Finds text position (case-sensitive).
FIND(find_text, within_text, [start_num])
Categoria: Texto
SEARCH
★★☆Finds text position (case-insensitive).
SEARCH(find_text, within_text, [start_num])
Categoria: Texto
REPLACE
★★☆Replaces part of text based on position.
REPLACE(old_text, start_num, num_chars, new_text)
Categoria: Texto
SUBSTITUTE
★★☆Substitutes occurrences of text with new text.
SUBSTITUTE(text, old_text, new_text, [instance_num])
Categoria: Texto
TEXT
★★☆Formats value as text using a format code.
TEXT(value, format_text)
Categoria: Texto
TEXTJOIN
★★☆Joins text values with a delimiter.
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Categoria: Texto
CONCAT
★☆☆Concatenates multiple text values.
CONCAT(text1, [text2], ...)
Categoria: Texto
CONCATENATE
★☆☆Legacy function to concatenate text values.
CONCATENATE(text1, [text2], ...)
Categoria: Texto
TRIM
★☆☆Removes extra spaces from text.
TRIM(text)
Categoria: Texto
CLEAN
★★☆Removes non-printable characters.
CLEAN(text)
Categoria: Texto
UPPER
★☆☆Converts text to uppercase.
UPPER(text)
Categoria: Texto
LOWER
★☆☆Converts text to lowercase.
LOWER(text)
Categoria: Texto
PROPER
★☆☆Capitalizes the first letter of each word.
PROPER(text)
Categoria: Texto
VALUE
★★☆Converts text that represents a number into number.
VALUE(text)
Categoria: Texto
TODAY
★☆☆Returns current date.
TODAY()
Categoria: Fecha/Hora
NOW
★☆☆Returns current date and time.
NOW()
Categoria: Fecha/Hora
DATE
★☆☆Builds a date from year, month, day.
DATE(year, month, day)
Categoria: Fecha/Hora
TIME
★☆☆Builds a time from hour, minute, second.
TIME(hour, minute, second)
Categoria: Fecha/Hora
YEAR
★☆☆Extracts year from a date.
YEAR(serial_number)
Categoria: Fecha/Hora
MONTH
★☆☆Extracts month from a date.
MONTH(serial_number)
Categoria: Fecha/Hora
DAY
★☆☆Extracts day from a date.
DAY(serial_number)
Categoria: Fecha/Hora
WEEKDAY
★★☆Returns day-of-week number.
WEEKDAY(serial_number, [return_type])
Categoria: Fecha/Hora
WEEKNUM
★★☆Returns week number in a year.
WEEKNUM(serial_number, [return_type])
Categoria: Fecha/Hora
EDATE
★★☆Returns date shifted by specified months.
EDATE(start_date, months)
Categoria: Fecha/Hora
EOMONTH
★★☆Returns last day of month shifted by months.
EOMONTH(start_date, months)
Categoria: Fecha/Hora
DATEDIF
★★☆Returns difference between dates in selected unit.
DATEDIF(start_date, end_date, unit)
Categoria: Fecha/Hora
NETWORKDAYS
★★☆Returns number of working days between dates.
NETWORKDAYS(start_date, end_date, [holidays])
Categoria: Fecha/Hora
NETWORKDAYS.INTL
★★★Returns working days with customizable weekends.
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Categoria: Fecha/Hora
WORKDAY
★★☆Returns date shifted by working days.
WORKDAY(start_date, days, [holidays])
Categoria: Fecha/Hora
WORKDAY.INTL
★★★Returns workday-based date with customizable weekends.
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Categoria: Fecha/Hora
ROUND
★☆☆Rounds a number to specified digits.
ROUND(number, num_digits)
Categoria: Matematicas
ROUNDUP
★☆☆Rounds a number up.
ROUNDUP(number, num_digits)
Categoria: Matematicas
ROUNDDOWN
★☆☆Rounds a number down.
ROUNDDOWN(number, num_digits)
Categoria: Matematicas
INT
★☆☆Rounds number down to nearest integer.
INT(number)
Categoria: Matematicas
MROUND
★★☆Rounds number to nearest specified multiple.
MROUND(number, multiple)
Categoria: Matematicas
CEILING
★★☆Rounds number up to nearest multiple.
CEILING(number, significance)
Categoria: Matematicas
FLOOR
★★☆Rounds number down to nearest multiple.
FLOOR(number, significance)
Categoria: Matematicas
ABS
★☆☆Returns absolute value.
ABS(number)
Categoria: Matematicas
MOD
★☆☆Returns remainder after division.
MOD(number, divisor)
Categoria: Matematicas
SUMPRODUCT
★★★Returns sum of products of arrays.
SUMPRODUCT(array1, [array2], ...)
Categoria: Matematicas
PRODUCT
★☆☆Returns product of given numbers.
PRODUCT(number1, [number2], ...)
Categoria: Matematicas
RAND
★☆☆Returns random number between 0 and 1.
RAND()
Categoria: Matematicas
RANDBETWEEN
★☆☆Returns random integer between two numbers.
RANDBETWEEN(bottom, top)
Categoria: Matematicas
FILTER
★★☆Filters rows using include condition.
FILTER(array, include, [if_empty])
Categoria: Matriz dinamica
SORT
★★☆Sorts an array by specified index/order.
SORT(array, [sort_index], [sort_order], [by_col])
Categoria: Matriz dinamica
SORTBY
★★★Sorts array by another array.
SORTBY(array, by_array1, [sort_order1], ...)
Categoria: Matriz dinamica
UNIQUE
★★☆Returns unique values from a range.
UNIQUE(array, [by_col], [exactly_once])
Categoria: Matriz dinamica
SEQUENCE
★★☆Generates sequential numbers in an array.
SEQUENCE(rows, [columns], [start], [step])
Categoria: Matriz dinamica
ISBLANK
★☆☆Checks whether value is blank.
ISBLANK(value)
Categoria: Informacion
ISNUMBER
★☆☆Checks whether value is a number.
ISNUMBER(value)
Categoria: Informacion
ISTEXT
★☆☆Checks whether value is text.
ISTEXT(value)
Categoria: Informacion
ISERROR
★★☆Checks whether value is any error.
ISERROR(value)
Categoria: Informacion
ISNA
★★☆Checks whether value is #N/A error.
ISNA(value)
Categoria: Informacion
Buscar por comparaciones y por tarea
Si no sabes el nombre exacto de la funcion, revisa primero comparaciones y guias por operacion.