ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Array functions

With an array formula it's possible to perform several calculations and return either one single result or multiple results to several target cells. Array formulas works with two or more sets of values called array arguments. All array arguments must have the same number of rows and columns.
You can make an array formula like this:

  1. Select the cell or the range in which you want to enter the array formula.
  2. Enter the formula like any other worksheet formula (without the brackets).
  3. Press Ctrl+Shift+Enter to update the array formula.

The array formula is now visible in the formula bar within two brackets..

 

Document last updated 1999-08-14 12:44:13      Printerfriendly version

User comments:
Ole P. from Norway wrote (2004-05-18 19:26:24 CET):
Re: Daily Sales Outstanding Calc
If you select the menu item "Adding" in the menu on the left, you will find a document named "Sum function examples" that contains example formulas that will solve your problem.
You can also take a look at the built-in help regarding the SUMIF worksheet function.
Jay from UK wrote (2004-05-18 16:15:25 CET):
Daily Sales Outstanding Calc
I have a range of cells arranged in month order, which contain sales data, I wish to only sum those sales figures that are equal to or less than a specific value e.g. the current month debtors value. Do you know of any vba array example that I can use or worksheet functions?

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address