SUMIF: Basic SUMIF function from excel

In ExcelFunctionsR: Imports Excel Functions to R

Description

It acts similiarly to Excel's SUMIF function. It sums the values where certain criterias are met.

Usage

SUMIF(range, criteria, sum_range)

Arguments

range	Which range should it check the criteria against.
criteria	what criteria should it check in range
sum_range	Which range should it sum

Value

In this case we are summing Sepal length of species which are virginica. Function will always return numeric class.

Examples

SUMIF(iris$Species,"virginica",iris$Sepal.Length)

Example output

[1] 329.4
Warning message:
In SUMIF(iris$Species, "virginica", iris$Sepal.Length) :
  NAs introduced by coercion

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