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
Advertisements