daverage.xlsx
TRANSCRIPT
7/29/2019 Daverage.xlsx
http://slidepdf.com/reader/full/daveragexlsx 1/2
Excel Function Dictionary
© 1998 - 2000 Peter Noneley
DAVERAGE
Page 1 of 2
1
2
3
45
6
7
8
9
10
11
12
13
14
15
16
1718
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
3940
41
42
43
44
45
46
47
A B C D E F G H I J
DAVERAGEThis is the Database range.
Product Wattage
Life
Hours Brand Unit Cost
Box
Quantity
Boxes In
Stock
Value Of
Stock
Bulb 200 3000 Horizon £4.50 4 3 £54.00Neon 100 2000 Horizon £2.00 15 2 £60.00
Spot 60 £0.00
Other 10 8000 Sunbeam £0.80 25 6 £120.00
Bulb 80 1000 Horizon £0.20 40 3 £24.00
Spot 100 unknown Horizon £1.25 10 4 £50.00
Spot 200 3000 Horizon £2.50 15 0 £0.00
Other 25 unknown Sunbeam £0.50 10 3 £15.00
Bulb 200 3000 Sunbeam £5.00 3 2 £30.00
Neon 100 2000 Sunbeam £1.80 20 5 £180.00
Bulb 100 unknown Sunbeam £0.25 10 5 £12.50
Bulb 10 800 Horizon £0.20 25 2 £10.00
Bulb 60 1000 Sunbeam £0.15 25 0 £0.00
Bulb 80 1000 Sunbeam £0.20 30 2 £12.00Bulb 100 2000 Horizon £0.80 10 5 £40.00
Bulb 40 1000 Horizon £0.10 20 5 £10.00
To calculate the Average cost of a particular Brand of bulb.
Brand These two cells are the Criteria range.
Type the brand name : sunbeam
The Average cost of sunbeam is : £1.24 =DAVERAGE(B3:I19,F3,E23:E24)
What Does It Do ?
This function examines a list of information and produces and average.
Syntax
=DAVERAGE(DatabaseRange,FieldName,CriteriaRange)
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, suchas Horizon as a brand name, or 100 as the wattage.
Formatting
No special formatting is needed.
Examples
The average Unit Cost of a particular Product of a particular Brand.
7/29/2019 Daverage.xlsx
http://slidepdf.com/reader/full/daveragexlsx 2/2
Excel Function Dictionary
© 1998 - 2000 Peter Noneley
DAVERAGE
Page 2 of 2
48
49
50
51
52
5354
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
A B C D E F G H I J
Product Brand
Bulb Horizon
The average of Horizon Bulb is : £1.16 =DAVERAGE(B3:I19,F3,E49:F50)
This is the same calculation but using the actual name "Unit Cost" instead of the cell address.
£1.16 =DAVERAGE(B3:I19,"Unit Cost",E49:F50)
The average Unit Cost of a Bulb equal to a particular Wattage.
Product Wattage
Bulb 100
Average of Bulb 100 is : £0.53 =DAVERAGE(B3:I19,"Unit Cost",E60:F61)
The average Unit Cost of a Bulb less then a particular Wattage.
Product Wattage
Bulb <100
Average of Bulb <100 is : £0.17 =DAVERAGE(B3:I19,"Unit Cost",E67:F68)