Leading the way in Microsoft Office Development

Excel

COUNT and SUM Functions

You can use the COUNTIF() and SUMIF() to quickly return the number of cells or the total value for a given criteria.

It is possible though to obtain the same information just by using the regular SUM() function with array formulas.

COUNT Matching Rows

You can use the COUNTIF() to return the number of cells that satisfy a given criteria.

Alternatively you can also use the SUM() function with array formulas.

What is the total number of transactions where Quantity = 5

What is the total number of transactions where Quantity = 5 or Quantity = 10

What is the total number of transactions where Quantity = 5 and Location = New York

SUM Matching Rows

You can use the SUMIF() to add the cells specified by a given criteria.

Alternatively you can also use the SUM() function with array formulas.

What is the total price for all the transactions where Quantity = 5

What is the total price for all the transactions where Quantity = 5 or Quantity = 10

What is the total price for all the transactions where Quantity = 5 and Location = New York