Skip to content
TechnoLearnAcademy
TECHNOLEARN
Menu
Home
About us
Trainer
Contact us
Fee
Login
Register
Previous
Next
Home
EXCEL SUMIF
The Sumif
is an Excel function to sum the values in a range based on specific criteria.
Syntax
:
=Sumif(range,criteria,[sum_range])
Arguments or Parameters:
range:
a range of cells or an array.
criteria:
specify the condition in which cells should be sum.
Sum_range
[optional]: It is the range of cells to sum together.
Objective
: Find the count of Dell Products in cell H4.
   Step 1
:
Type = sign in cell I3
Type
Sumif
Function
 Â
Step 2
:
Select range
D2:D23
Type “,”
   Step 3:
Type G4 in criteria
Type “,”
Select range
E3:E23
in [
sum_range
]
Close Bracket with “)”
Press
Enter
Conclusion
: The
SUMIF
formula in
cell
H4 calculated the sum of Dell’s values as
656
.
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