To calculate the Average cost of a particular Brand of bulb.
Type the brand name : sunbeam
The Average cost of sunbeam is : £1.24
What Does It Do ?
This function examines a list of information and produces and average.
The DatabaseRange is the entire list of information you need to examine, including the
field names at the top of the columns.
The FieldName is the name, or cell, of the values to be averaged, such as "Unit Cost" or F3.
The CriteriaRange is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.
The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.
No special formatting is needed.
The average Unit Cost of a particular Product of a particular Brand.