The sumif function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.
 |
| CREATED BY PECULIA AND FARIDAH |
For Example: you would
use sumifs to sum the number of
retailers in the country who (1) reside
in a single zip code and (2) whose profit exceed a specific dollar value
The sumif function is a premade function in excel, which
calculates the sum of values in a range
based on a true or false condition.
FORMULAR
OF SUMIF IN EXCEL
For example the
formular =sumif CB2-B5,”john”(2.C5) sum
only the values in the range (2.C5,
where the corresponding cells in the range B2:B5 equal (“john “ it is typed
=sumifs. =sumifs (sum-range –criteria-range1, criteria [criteria –range
2,criteria 2 ]…)
FUNCTION
OF SUMIFS ON MIRCOFSOFT EXCEL
For example
=sumif(A2:Aa,B2:Ba”A*,C2:C9” “T0 ”)will add instanas with the name that begin
with “TO and “ends with a last letter that could vary understand the difference
between sumif and sumifs. The order of arguments differ between sumif and
sumifs.
HOW
DO YOU USE SUMIF FUNTIONS IN A TABLE
1. Prepare
a table with multiple column
2. Determine
the values you want to add up
3. Select
Your First Criteria and range
4. Add
other Criteria and range
The sumifs function is premade function in Excel, which calculates the sum of a range based on one or more true or false condition. It is typed= sumif =sumif(sum-range ,criteria-range1, criteria1,[criteria-range2, criteria2 ]…)
TABLE ON SUMIF FUNCTION
IN MICROSOFT EXCEL
|
ORDER |
DATE
ITEM |
STATE |
TOTAL |
|
1001 |
1-JAN
SHORT |
CA |
$32,00 |
|
1001 |
1-JAN
HOODIE |
CA |
$34,00 |
|
1002 |
2-JAN
T-SHIRT |
CA |
$18.00 |
|
1003 |
3-JANT-SHIRT |
CA |
$18.00 |
|
1004 |
3-JAN
SHORT |
OR |
$32.00 |
|
1004 |
3-JAN
HOODIE |
OR |
$34.00 |
|
1004 |
3-JAN
HAT |
OR |
$16.00 |
|
1005 |
4-JAN
SHORT |
ID |
$32.00 |
|
1005 |
4-JAN
HOODIE |
ID |
$34.00 |
|
1006 |
5-JAN
T-SHIRT |
CA |
$18.00 |
|
1006 |
5-JAN
T-SHIRT |
CA |
$18.00 |
|
1007 |
7-JAN
T-SHIRT |
CA |
$18.00 |
|
ITEM |
TOTAL |
|
SHORTS |
$288.00 |
|
HOODIE |
$850.00 |
|
T-SHITE |
$342.00 |
|
HAT |
$288.00 |
|
SANDALS |
$336.00 |
Sumif
function can work in excel like
If you want, you can apply the criteria to one
range and sum the corresponding values in a different range.
FOR
EXAMPLE, the formular
=sumif
(B2:B5,”JOHN”,C2:C5) SUM only the values in the range C2:C5, where the
corresponding cells in the range B2:B5 equal “JOHN”
The
sumif function most useful to calculate total sales of a specific product, sum
expenses for a particular category, or determine the total quantity of item
sold within a certain region
The
sumif function is a common widely used function in excel and can be used to sum
cells based on dates, text values, and
numbers sumif supports logical operators such as (>,<,=)and also wild
card(*,?)
THIS
IS THE END OF SUMIF PRESENTATION
THANKYOU!
CREATED BY:
PECULIAR AND FARIDAH
0 comments:
Post a Comment