MAXIFS {ExcelFunctionsR}

Basic MAXIFS function from excel

Description

It acts similiarly to Excel's MAXIFS function. It returns the maximum value from an array after testing for several criterias.

Usage

MAXIFS(
  max_range,
  criteria_range1,
  criteria1,
  criteria_range2 = TRUE,
  criteria2 = TRUE,
  criteria_range3 = TRUE,
  criteria3 = TRUE,
  criteria_range4 = TRUE,
  criteria4 = TRUE,
  criteria_range5 = TRUE,
  criteria5 = TRUE,
  criteria_range6 = TRUE,
  criteria6 = TRUE,
  criteria_range7 = TRUE,
  criteria7 = TRUE,
  criteria_range8 = TRUE,
  criteria8 = TRUE,
  criteria_range9 = TRUE,
  criteria9 = TRUE,
  criteria_range10 = TRUE,
  criteria10 = TRUE
)

Arguments

max_range

Range from where it should return the maximum value from.

criteria_range1, criteria_range2, criteria_range3, criteria_range4, criteria_range5, criteria_range6, criteria_range7, criteria_range8, criteria_range9, criteria_range10

Which range should the criteria tested for.Only criteria_range1 is mandatory,others are optional.

criteria1, criteria2, criteria3, criteria4, criteria5, criteria6, criteria7, criteria8, criteria9, criteria10

What criteria should the range be checked against. Only criteria1 is mandatory, others are optional.

Value

This example returns maximum value of Petal Length of species setosa who have petal width 0.2. Function will always return numeric class.

Examples

MAXIFS(iris$Petal.Length,iris$Species,"setosa",iris$Petal.Width,0.2)