Forum Login | Courses Login

SUMPRODUCT Formula in Excel

SUMPRODUCT Formula in Excel

by | Jun 11, 2020 | Online Business Courses

How to use the SUMPRODUCT Formula in Excel The The SUMPRODUCT formula returns the sum of the products of corresponding ranges. The default operation is multiplication, but addition, subtraction, and division are also possible. The SUMPRODUCT formula was used more...
COUNTIFS Formula in Excel

COUNTIFS Formula in Excel

by | Jun 11, 2020 | Online Business Courses

How to use the COUNTIFS Formula in Excel The COUNTIFS formula is a formula used to apply multiple criteria to a range of cells to count the number of times it meets all of those criteria. The formula applies criteria to cells across multiple ranges and counts the...
COUNTIF Formula in Excel

COUNTIF Formula in Excel

by | Jun 11, 2020 | Online Business Courses

How to Use the COUNTIF Formula in Excel The COUNTIF formula is typically used to count the number of cells that meet a certain criterion. Note that the COUNTIF formula is used to identify only one condition. So if you need to identify more than one condition, you...
AVERAGEIFS Formula in Excel

AVERAGEIFS Formula in Excel

by | Jun 11, 2020 | Online Business Courses

The AVERAGEIFS Formula returns the average (arithmetic mean) of a range of cells that meet multiple conditions or criteria. This is different than the AVERAGEIF formula as multiple criteria exist that you want to take into consideration when performing the average...