To calculate lowest Value Of Stock of a particular Brand of bulb.
Criteria Range Is E23:E24
DATABASE FORMULA – DAVERAGE Function
What Does It Do ?
This function examines a list of information and produces an average.
Description For DAVERAGE Function
- 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.
Criteria Range Is E49:F50
The average of Horizon Bulb is : =DAVERAGE(B3:I19,F3,E49:F50)
This is the same calculation but using the actual name “Unit Cost” instead of the cell address.
The average Unit Cost of a Bulb equal to a particular Wattage.
Criteria Range Is E60:F61
Average of Bulb 100 is =DAVERAGE(B3:I19,”Unit Cost”,E60:F61)
The average Unit Cost of a Bulb less then a particular Wattage.
Criteria Range Is E67:F68
Average of Bulb <100 is: =DAVERAGE(B3:I19,”Unit Cost”,E67:F68)
Advanced Excel Formulas Index