totn Excel

MS Excel: Array Formulas

The following is a list of topics that explain how to use Array Formulas in Excel:

Sum Values

  • Use an array formula to sum values in Column A when value in Column B and Column C match criteria in Excel 2003
  • Use an array formula to sum values in Column AB when value in Column E and Column AB match criteria in Excel 2003
  • Use an array formula to sum all of the order values for a given client in Excel 2007

Count Values

  • Use an array formula to count ranges of times in Excel 2003
  • Use an array formula to count the number of children who will attend lunch in Excel 2003
  • Use an array formula to count the number of rows that match 2 criteria in Excel 2003
  • Use an array formula to count the number of occurrences when the value in column A is greater than or equal to the value in column D in Excel 2003
  • Use an array formula to count the number of dates exceeding 12 months in Excel 2007
  • Use an array formula to calculate monthly attendance in Excel 2003
  • Use an array formula to count matches on multiple values in one column in Excel 2007
  • Use an array formula to count the number of rows when column F and column L match criteria in Excel 2003

Average Values

  • Use an array formula to average values when 2 criteria are met in Excel 2003

Miscellaneous

  • Use an array formula to perform a two criteria lookup in Excel 2003