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

## Description

It acts similiarly to Excel's COUNTIFS function. Counts values in a range which comply with given criteria.

## Usage

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

 `criteria_range1, criteria_range2, criteria_range3, criteria_range4, criteria_range5, criteria_range6, criteria_range7, criteria_range8, criteria_range9, criteria_range10` Specify range for Countifs, only criteria_range1 is mandatory. `criteria1, criteria2, criteria3, criteria4, criteria5, criteria6, criteria7, criteria8, criteria9, criteria10` Give the criteria to check the range for.Only criteria1 is necessary, others are optional.

## Value

In this example we count the amount of cells where Spcies are setosa and has a Petal Width of 0.2 .Function will always return numeric class.

## Examples

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

### Example output

```[1] 29
Warning message:
In COUNTIFS(iris\$Species, "setosa", iris\$Petal.Width, 0.2) :
NAs introduced by coercion
```

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