# SUMIFS: Basic SUMIFS function from excel In ExcelFunctionsR: Imports Excel Functions to R

## Description

It acts similiarly to Excel's SUMIFS function. It sums the values where several criterias are met(it mimics and expression for criterias).

## Usage

 ``` 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23``` ```SUMIFS( sum_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

 `sum_range` Which range should it sum `criteria_range1, criteria_range2, criteria_range3, criteria_range4, criteria_range5, criteria_range6, criteria_range7, criteria_range8, criteria_range9, criteria_range10` Which range should it check the criteria against. Only criteria_range1 is mandatory, others are optional. `criteria1, criteria2, criteria3, criteria4, criteria5, criteria6, criteria7, criteria8, criteria9, criteria10` what criteria should it check in range. Only criteria1 is mandatory, others are optional.

## Value

In this example we sum the petal length of all setosa species which have petal width of 0.2. Function will always return numeric class.

## Examples

 `1` ```SUMIFS(iris\$Petal.Length,iris\$Species,"setosa",iris\$Petal.Width,0.2) ```

### Example output

```[1] 41.9
Warning message:
In SUMIFS(iris\$Petal.Length, iris\$Species, "setosa", iris\$Petal.Width,  :
NAs introduced by coercion
```

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.