Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Home
Previous
Next
EXCEL AVERAGEIF
The
AVERAGEIF
is an Excel function used to calculate an average of all cells in a given range that meet a certain             condition.
Syntax
:
      =AVERAGEIF(range,criteria,[average_range])
Arguments or Parameters:
range:
a range of cells or an array.
criteria:
specify the condition which cells to average.
Average_range
[optional]: it is the range of cells you want to average.
Objective
: Find the average Price of Dell Products
cell
H2.
   Step 1
:
Type = sign in cell
H2
.
Type
AverageIf
Function
 Â
Step 2
:
Select range
D3:D22
Type “,”
   Step 3:
Type “Dell” in criteria
Type “,”
Select range
E3:E23
in [
sum_range
]
Close Bracket with “)”
Press
Enter
Conclusion
: AverageIf formula has given the Average Price Of Dell Products in Cell H2.
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
DOWNLOAD SYLLABUS SQL
Mobile
Email
×
DOWNLOAD SYLLABUS
Mobile
Email
×
Scroll to Top